Postgres Pro
Downloads
Home   >   mailing lists

Re: postgres 7.4 at 100% - Mailing list pgsql-performance

From Doug McNaught
Subject Re: postgres 7.4 at 100%
Date
Msg-id 87llia78dj.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to postgres 7.4 at 100%  (Chris Cheston <ccheston@gmail.com>)
Responses Re: postgres 7.4 at 100%
List pgsql-performance
Tree view 
Chris Cheston <ccheston@gmail.com> writes:

> shared_buffers = 40             # min 16, at least max_connections*2, 8KB each

This is ridiculously low for any kind of production server.  Try
something like 5000-10000 for a start.

-Doug

pgsql-performance by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: How can one see what queries are running withing a
Next
From: "Joshua D. Drake"
Date:
Subject: Re: postgres 7.4 at 100%