Re: performance tuning: shared_buffers, sort_mem; swap

>>>>> "Tom" == Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

[on shared memory size, deleted]

Tom> There are also a number of fixed-size data structures in shared
Tom> memory, and I believe we throw on a 10% fudge factor for good
Tom> luck after we're done counting up what we think we need.

Tom> You could work out the effective multipliers for these parameters
Tom> with a little bit of experimental effort...

I don't often ask a question, but it's been bugging me for some time:
is there any reason why PostgreSQL must use SysV shared memory?
Coming from the BSD camp, I've often pondered why it doesn't use
BSD-style shared memory (which is often easier to allocate in the BSD
world).

Dave.

--
============================================================================
|David Gilbert, Velocet Communications. | Two things can only be |
|Mail: dgilbert(at)velocet(dot)net | equal if and only if they |
|http://daveg.ca | are precisely opposite. |
=========================================================GLO================