From: smiley2211 <smiley2211@yahoo.com>
To: pgsql-performance@postgresql.org
Subject: Re: Postgresql.conf Settings
Date: Sun, 4 Nov 2007 10:30:28 -0800 (PST)
Message-ID: <13576252.post@talk.nabble.com> (raw)
In-Reply-To: <dcc563d10711040937w2a50d74fh26531e1932a81a23@mail.gmail.com>
References: <13575017.post@talk.nabble.com>
<dcc563d10711040937w2a50d74fh26531e1932a81a23@mail.gmail.com>
Scott,
Thanks for responding...I've posted all that information before and tried
all the suggestions but the query is still taking over 1 hour to complete
:(...I just wanted to possible hear what others have say 'effective cache',
'shared_buffers' etc set to...
Thanks...Marsha
Scott Marlowe-2 wrote:
>
> On 11/4/07, smiley2211 <smiley2211@yahoo.com> wrote:
>>
>> Hello all,
>>
>> What are the ideal settings for values in this postgresql.conf file??? I
>> have tried so many parameter changes but I still can not get the 8.1.4
>> version to perform as well as the 7.x version...what do others have their
>> postgrsql.conf file values set to???
>
> Without knowing what query you're trying to run it's hard to say.
>
> Can you post the explain analyze output for the query in both 7.x and 8.1?
>
>> Are there any known performance degrades going from 7.x to 8.1
>> versions???
>
> The only one I know of is if you try to do something like:
>
> select * from table1 t1 left join table2 t2 on (t1.id=t2.id) where t2.id
> is null
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate
>
>
--
View this message in context: http://www.nabble.com/Postgresql.conf-Settings-tf4747486.html#a13576252
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: smiley2211@yahoo.com
Subject: Re: Postgresql.conf Settings
In-Reply-To: <13576252.post@talk.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox