Re: optimum settings for dedicated box

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@yahoo.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
>