Postgres Pro
Downloads
Home   >   mailing lists

Re: Trouble getting effective_cache_size parameter to take - Mailing list pgsql-general

From Tom Lane
Subject Re: Trouble getting effective_cache_size parameter to take
Date
Msg-id 263.1207662757@sss.pgh.pa.us
Whole thread Raw
In response to Trouble getting effective_cache_size parameter to take  ("Hardwick, Joe" <Joe.Hardwick@fnis.com>)
Responses Re: Trouble getting effective_cache_size parameter to take  ("Hardwick, Joe" <Joe.Hardwick@fnis.com>)
List pgsql-general
Tree view 
"Hardwick, Joe" <Joe.Hardwick@fnis.com> writes:
> I've got a Postgres v8.2.4 server that we recently upped from 2GB RAM to
> 6GB.  I added:

> effective_cache_size = 5120MB

> to the postgresql.conf file but when I restart the server and do a "show
> all" it always comes back with "1000MB".  I can set it manually and it
> takes but for some reason it just seems to ignore it in the config file.

Sure sounds to me like you're editing the wrong config file ...

            regards, tom lane

pgsql-general by date:

Previous
From: Zdenek Kotala
Date:
Subject: Re: "too many trigger records found for relation xyz"
Next
From: Simone Brunozzi
Date:
Subject: Postgresql Conferences/events in Europe?