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
1. mailto:Fabian.Groffen@cwi.nl 2. mailto:JLP00993@correo.aeat.es