Re: [GENERAL] Trouble getting effective_cache_size parameter to take

2008-04-09 Thread Hardwick, Joe
l.org Subject: Re: [GENERAL] Trouble getting effective_cache_size parameter to take "Hardwick, Joe" <[EMAIL PROTECTED]> 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 p

Re: [GENERAL] Trouble getting effective_cache_size parameter to take

2008-04-08 Thread Tom Lane
"Hardwick, Joe" <[EMAIL PROTECTED]> 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

[GENERAL] Trouble getting effective_cache_size parameter to take

2008-04-08 Thread Hardwick, Joe
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 s