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:doug@hunley.homeip.net]
Sent: Sunday, June 03, 2007 02:30 PM Eastern Standard Time
To: Tom Lane
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] upgraded to pgsql 8.2.4, getting worse performance then 7.4.x

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 to
the file? The file I sent is the working copy from the machine in question.

--
Douglas J Hunley (doug at hunley.homeip.net) - Linux User #174778
http://doug.hunley.homeip.net

"Does it worry you that you don't talk any kind of sense?"

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

On Sunday 03 June 2007 16:39:51 Luke Lonergan wrote:
> When you initdb, a config file is edited from the template by initdb to
> reflect your machine config.

I didn't realize that. I'll have to harass the rest of the team to see if
someone overwrote that file or not. In the interim, I did an 'initdb' to
another location on the same box and then copied those values into the config
file. That's cool to do, I assume?

--
Douglas J Hunley (doug at hunley.homeip.net) - Linux User #174778
http://doug.hunley.homeip.net

Cowering in a closet is starting to seem like a reasonable plan.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Douglas J Hunley wrote:
> On Sunday 03 June 2007 16:39:51 Luke Lonergan wrote:
>> When you initdb, a config file is edited from the template by initdb to
>> reflect your machine config.
>
> I didn't realize that. I'll have to harass the rest of the team to see if
> someone overwrote that file or not. In the interim, I did an 'initdb' to
> another location on the same box and then copied those values into the config
> file. That's cool to do, I assume?

Yeah, that's ok.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster