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