[PERFORM] Tuning shared_buffers with ipcs ?

2004-10-15 Thread Doug Y
Hello, I've seen a couple references to using ipcs to help properly size shared_buffers. I don't claim to be a SA guru, so could someone help explain how to interpret the output of ipcs and how that relates to shared_buffers? How does one determine the size of the segment arrays? I see the

Re: [PERFORM] Tuning shared_buffers with ipcs ?

2004-10-15 Thread Tom Lane
Doug Y [EMAIL PROTECTED] writes: I've seen a couple references to using ipcs to help properly size shared_buffers. I have not seen any such claim, and I do not see any way offhand that ipcs could help. I tried all of the dash commands in the ipcs man page, and the only one that might give

Re: [PERFORM] Tuning shared_buffers with ipcs ?

2004-10-15 Thread Doug Y
Tom Lane wrote: Doug Y [EMAIL PROTECTED] writes: I've seen a couple references to using ipcs to help properly size shared_buffers. I have not seen any such claim, and I do not see any way offhand that ipcs could help. Directly from:

Re: [PERFORM] Tuning shared_buffers with ipcs ?

2004-10-15 Thread Tom Lane
Doug Y [EMAIL PROTECTED] writes: Tom Lane wrote: I have not seen any such claim, and I do not see any way offhand that ipcs could help. Directly from: http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html As a rule of thumb, observe shared memory usage of PostgreSQL with