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
>