| From: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
|---|---|
| To: | iharding(at)destinydata(dot)com |
| Cc: | "Matt A(dot)" <survivedsushi(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: optimum settings for dedicated box |
| Date: | 2005-08-31 05:03:15 |
| Message-ID: | 20050831050314.GR77007@pervasive.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)pervasive(dot)com
Pervasive Software http://pervasive.com 512-569-9461
| From | Date | Subject | |
|---|---|---|---|
| Next Message | gokulnathbabu manoharan | 2005-08-31 05:31:09 | Re: Invalid page header in pg_class |
| Previous Message | Ian Harding | 2005-08-31 04:43:19 | Re: optimum settings for dedicated box |