Re: Trouble getting effective_cache_size parameter to take

Turns out someone had placed a second line further down in the file I
didn't realize was there... So it set it, then reset it.

Thanks,
Joe

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Tuesday, April 08, 2008 8:53 AM
To: Hardwick, Joe
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Trouble getting effective_cache_size parameter to
take

"Hardwick, Joe" <Joe(dot)Hardwick(at)fnis(dot)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

______________

The information contained in this message is proprietary and/or confidential. If you are not the
intended recipient, please: (i) delete the message and all copies; (ii) do not disclose,
distribute or use the message in any manner; and (iii) notify the sender immediately. In addition,
please be aware that any message addressed to our domain is subject to archiving and review by
persons other than the intended recipient. Thank you.
_____________