"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 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general