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. <[EMAIL PROTECTED]> 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 > ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
