29 Nov
2006
29 Nov
'06
9:14 a.m.
On 29-11-2006 09:51:48 +0100, Wouter Scherphof wrote:
On 11/29/06, Fabian Groffen <[1]Fabian.Groffen@cwi.nl> wrote:
On 29-11-2006 09:33:27 +0100, [2]JLP00993@correo.aeat.es wrote:
I would try to load about 300.000.000 registers with 80 fields each one (150 GBytes) in Monet V4.12.0 database.
I think this is not going to work with current MonetDB very well.
Could you explain why this wouldn't work very well?
150GB/80 cols ~= 1.9GB per column, assuming they are all of equal size. You need at least 2GB of memory, but from experiences this usually blows up somehow, triggering a lot of disk IO (swapping). The real case will prove how it performs, of course. We have better results with larger scaling factors on MonetDB 5.
Regards, Wouter.
Referenties
- mailto:Fabian.Groffen@cwi.nl
- mailto:JLP00993@correo.aeat.es