From: | smiley2211 <smiley2211(at)yahoo(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Postgresql.conf Settings |
Date: | 2007-11-04 18:30:28 |
Message-ID: | 13576252.post@talk.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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(at)yahoo(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2007-11-04 19:30:12 | Re: Postgresql.conf Settings |
Previous Message | Scott Marlowe | 2007-11-04 17:37:02 | Re: Postgresql.conf Settings |