Re: Trouble getting effective_cache_size parameter to take

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Hardwick, Joe" <Joe(dot)Hardwick(at)fnis(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Trouble getting effective_cache_size parameter to take
Date: 2008-04-08 13:52:37
Message-ID: 263.1207662757@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2008-04-08 13:53:57 Re: Functions and transactions
Previous Message Zdenek Kotala 2008-04-08 13:47:30 Re: "too many trigger records found for relation xyz"