Re: [HACKERS] PC Week Labs benchmark results - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] PC Week Labs benchmark results
Date
Msg-id 12423.951543319@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] PC Week Labs benchmark results  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
I wrote:
> Timothy Dyck <Timothy_Dyck@zd.com> writes:
>> 8. Can't start postmaster with more than 65536 buffers as I get a "FATAL
>> 1:  couldn't initialize shared buffer pool Hash Tbl". Variable overflow?

> Probably.  Hadn't occurred to me that we need to check for a sane upper
> bound on the number of buffers, but I guess we do.  (You do realize that
> would be half a gig of in-memory buffers, right?  If you've actually got
> that much RAM, it's probably better to let the OS use it for general-
> purpose disk buffers instead of dedicating it all to Postgres.)

Just FYI, this is now fixed for 7.0.  Turns out there was a bogus
hard-wired assumption about the maximum size of the hashtable for
shared buffers.

I still doubt that anyone really *needs* more than 64K buffers ;-)
... but it will work if you have the RAM.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Don Baccus
Date:
Subject: Re: [HACKERS] LZTEXT for rule plan stings
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] ALTER TABLE DROP COLUMN