Re: optimum settings for dedicated box

On Tue, Aug 30, 2005 at 09:43:19PM -0700, Ian Harding wrote:
> Mine in similar, and the only thing I have changed from defaults is
> work_mem.  It made certain complex queries go from taking forever to
> taking seconds.  I have a database connection pool limited to 10
> connections, so I set it to 10MB.  That means (to me, anyway) that
> work_mem will never gobble more then 100MB.  Seems OK since I have
> 1GB.

That's not totally true. A single query can use work_mem for multiple
steps, so if work_mem is 10MB a single query could end up using 20MB,
30MB, or even more.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software        http://pervasive.com        512-569-9461