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@xxxxxxxxx> 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. ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
