From: | Ian Harding <harding(dot)ian(at)gmail(dot)com> |
---|---|
To: | "Matt A(dot)" <survivedsushi(at)yahoo(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: optimum settings for dedicated box |
Date: | 2005-08-31 04:43:19 |
Message-ID: | 725602300508302143d4599ae@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
Free space map should probably be tweaked too, if you have lots of
updates or deletes. I think.
- Ian
On 8/30/05, Matt A. <survivedsushi(at)yahoo(dot)com> wrote:
> Wondering what the optimum settings are for an
> dedicated postgresql database box? The box is an
> 2.8ghz processor, 1gig ram (soon will be 4) and raid 1
> (mirroring) across two 10k rpm SCSI disks. I only have
> a single database on it running linux of course. Thanks.
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jim C. Nasby | 2005-08-31 05:03:15 | Re: optimum settings for dedicated box |
Previous Message | Michael Fuhr | 2005-08-31 04:28:36 | Re: Help with SPI... |