Douglas J Hunley <[EMAIL PROTECTED]> writes:
> On Saturday 02 June 2007 11:25:11 Tom Lane wrote:
>> Another thing that seems strange is that the 8.2 config file does not
>> seem to have been processed by initdb --- or did you explicitly comment
>> out the settings it made?
> I don't understand thi
On Sun, 3 Jun 2007, Douglas J Hunley wrote:
commit_delay = 2
commit_siblings = 3
Those are based on a thread their (non-pgsql) DBA found online. I'm perfectly
willing to discount him if so advised.
Those likely came indirectly from the otherwise useful recommendations at
http://www.w
When you initdb, a config file is edited from the template by initdb to reflect
your machine config.
- Luke
Msg is shrt cuz m on ma treo
-Original Message-
From: Douglas J Hunley [mailto:[EMAIL PROTECTED]
Sent: Sunday, June 03, 2007 02:30 PM Eastern Standard Time
To: Tom Lane
C
On Saturday 02 June 2007 11:25:11 Tom Lane wrote:
> Another thing that seems strange is that the 8.2 config file does not
> seem to have been processed by initdb --- or did you explicitly comment
> out the settings it made?
I don't understand this comment. You are saying 'initdb' will make changes
On Saturday 02 June 2007 11:21:41 Michael Fuhr wrote:
> After the restore, did you ANALYZE the entire database to update
> the planner's statistics? Have you enabled autovacuum or are you
> otherwise vacuuming and analyzing regularly? What kind of queries
> are slower than desired? If you post a
