Re: Trouble getting effective_cache_size parameter to take

"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