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
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
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
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