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