Re: [GENERAL] Re: Memory Tuning

2001-03-31 Thread Bruce Momjian
> Bruno Wolff III <[EMAIL PROTECTED]> writes: > > Should I leave postgres tuning alone and let Linux use all of the memory > > for buffer caching? > > You shouldn't try to make Postgres consume *all* of memory for buffers; > for one thing, if the shmem region is too large then (at least on some >

Re: [GENERAL] Re: Memory Tuning

2001-03-31 Thread Tom Lane
Bruno Wolff III <[EMAIL PROTECTED]> writes: > Should I leave postgres tuning alone and let Linux use all of the memory > for buffer caching? You shouldn't try to make Postgres consume *all* of memory for buffers; for one thing, if the shmem region is too large then (at least on some Unixen, not s

[GENERAL] Re: Memory Tuning

2001-03-30 Thread Bruno Wolff III
On Fri, Mar 30, 2001 at 10:18:56AM -0500, Mitch Vincent <[EMAIL PROTECTED]> wrote: > If you could post the schema of your tables that you do the query against > and an EXPLAIN of the queries you're doing, perhaps we could further tune > your queries in addition to beefing up the memory usage of

[GENERAL] Re: Memory Tuning

2001-03-30 Thread Mitch Vincent
If you could post the schema of your tables that you do the query against and an EXPLAIN of the queries you're doing, perhaps we could further tune your queries in addition to beefing up the memory usage of the backend.. Check this link out too. http://postgresql.readysetnet.com/devel-corner/docs