20 Jul
2011
20 Jul
'11
7:30 a.m.
On Sun, Jul 17, 2011 at 12:41:44PM +0400, Eugene Prokopiev wrote:
...
The largest table we have used in house was 6-column table of 20 000 000 000 rows on a 64GB dual quad core machine. ... We have MonetDB running a ~2.5 TB database which contains (among others) one table with 20 000 000 000 rows.
Thanks, it's suitable for me. Are your databases for append data only or you use some algorithm to remove old historical data?
In the above mentioned (and most other) cases, our scenarios are mostly append only. Stefan -- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |