Dear Folks,
We have been running 6.4.2 under Linux on a dual Xeon box
with mostly good success. Our current dataset is 20 million records
of mostly numerical data (56 fields of floats [70%], ints [20%] and
a few text fields [10%]). The performance is acceptable, the only
problem so far has been the difficultly in floating type promotion
"confusing" the optimizer.
Our database is about to expans to 150 million records. Given
sufficient diskspace (e.g. a larger RAID array) will postgres
perform on this volume? Are there any gotchas? General comments
from people with experience with databases of this volume under
postgres?
Thanks!
--Martin
===========================================================================
Martin Weinberg Phone: (413) 545-3821
Dept. of Physics and Astronomy FAX: (413) 545-2117/0648
530 Graduate Research Tower
University of Massachusetts
Amherst, MA 01003-4525