Message-ID: <13576252.post@talk.nabble.com>
Date: Sun, 4 Nov 2007 10:30:28 -0800 (PST)
From: smiley2211 <smiley2211@yahoo.com>
To: pgsql-performance@postgresql.org
Subject: Re: Postgresql.conf Settings
In-Reply-To: <dcc563d10711040937w2a50d74fh26531e1932a81a23@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
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.