Tom Lane wrote:
Koichi Suzuki <[EMAIL PROTECTED]> writes:

Here're a couple of patches for PostgreSQL 64bit support.  There're just
two extension to 64bit, size of shared memory and transaction ID.


I asked originally for some experimental evidence showing any value
in having more than 2Gb of shared buffers.  In the absence of any
convincing demonstration, I'm not very inclined to worry about whether
we can handle wider-than-int shared memory size.

There is some practical evidence. Recently the number of large boxes in the field is almost growing exponentially. Today I have heard somebody say "this box has 'just 4 gig of ram' ". On large installations we have already seen problems with too small caches (= 2gb). Surprisingly this has turned out to be a quite important issue in the field. Tests have shown that the cache provided by the OS is a lot worse for the database.

64-bit XIDs seem to be an overkill - the only practical impact I can see is an even larger tuple header (this can be an issue on large boxes too - at least compared to Oracle).

        Best regards,

                Hans

---------------------------(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

Reply via email to