"Hardwick, Joe" <Joe.Hardwick@xxxxxxxx> 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
