Dealing about the hardware, for the moment we have only a bi-pentium Xeon 2.8Ghz with 4 Gb of RAM ... and we saw we had bad performance results ... so we are thinking about a new solution with maybe several servers (server design may vary from one to other) ... to get a kind of cluster to get better performance ...
The poor performance may not necessarily be:
i) attributable to the hardware or, ii) solved by clustering.
I would recommend determining *why* you got the slowdown. A few possible reasons are:
i) not vacuuming often enough, freespacemap settings too small. ii) postgresql.conf setting very non optimal. iii) index and/or data design not optimal for PG.
My suspicions would start at iii).
Other posters have pointed out that 250000000 records in itself is not necessarily a problem, so this sort of data size is manageable.
regards
Mark
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org