> Thanks again for your great documentation of the postgresql.conf
> settings. I've just revamped the Bricolage performance tuning docs
> after reading your comments on shared_buffers and sort_mem.
Cool! Especially as they're not finished yet.
> Question: Will you be posting these docs somewhere? I'd like to include
> a link to them in the Bricolage docs.
Yes. In fact, here's what's going to happen in the near future:
1) I will be providing completed tables for all variables for both 7.3.3 and
2) We will be re-ordering the Postgresql.conf variables for the 7.4 release
based on the more logical order I proposed, so that the order and grouping of
variables in the table will match Postgresql.conf and vice-versa (also the
official online docs).
3) I will be talking about this stuff at length at the next meeting. Be
> See the "Performance Tuning" section for the changes I made. An old
> example was setting shared_buffers to 20000!
Yeah, a lot of people made that mistake. Wanna print out that doc and bring
it with to the next meeting?
Aglio Database Solutions
In response to
sfpug by date
|Next:||From: David Wheeler||Date: 2003-06-05 16:29:21|
|Subject: Re: postgresql.conf Docs|
|Previous:||From: David Wheeler||Date: 2003-06-05 16:13:34|
|Subject: postgresql.conf Docs|