Re: [PERFORM] Postgresql.conf Settings

2007-11-04 Thread Heikki Linnakangas
smiley2211 wrote: 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??? Are there any known pe

Re: [PERFORM] Postgresql.conf Settings

2007-11-04 Thread smiley2211
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

Re: [PERFORM] Postgresql.conf Settings

2007-11-04 Thread Scott Marlowe
On 11/4/07, smiley2211 <[EMAIL PROTECTED]> 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 > postg

[PERFORM] Postgresql.conf Settings

2007-11-04 Thread smiley2211
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??? Are there any known performan