Various other posters have commented about the sweet-spot for shared_buffers being ~ 100-200M (or thereabouts).
So it seems to me that there is nothing to be gained using a 64-bit binary with the current or previous Pg releases. However, with the new cache replacement system being used in 7.5devel, the situation *may* be different (wonder if anyone has tried this out yet?).
regards
Mark
Andrew Sullivan wrote:
On Mon, Feb 09, 2004 at 12:46:58PM -0500, Christopher Browne wrote:
Lots of people have been running it on 64 bit systems for _years_ now.
The Digital Alpha architecture, for instance, was introduced in the
1992, and Sun UltraSPARC in 1995. PostgreSQL has been running well on
these sorts of systems for a lot of years now.
But actually, there are problems with using postgres as a 64 bit application on Solaris. It works, and it's reliable, but I've never seen any evidence that it helps anything (and I've looked plenty).
A
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
