Trouble getting effective_cache_size parameter to take

From: "Hardwick, Joe" <Joe(dot)Hardwick(at)fnis(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Trouble getting effective_cache_size parameter to take
Date: 2008-04-07 14:05:27
Message-ID: 1D134C5F69F974449CCE35EFBA14205B02089BA6@CMBFISLTC01.FNFIS.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Is there something else that needs to be present for this? I've tried
setting it in both the numeric-only and "MB" forms. I've included a
portion of the config at the end here, I realize it's probably not quite
right yet.

Thanks,
Joe

#-----------------------------------------------------------------------
----
# RESOURCE USAGE (except WAL)
#-----------------------------------------------------------------------
----

# - Memory -
shared_buffers = 600MB
work_mem = 100MB
maintenance_work_mem = 300MB
max_stack_depth = 5MB
effective_cache_size = 5120MB

______________

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.
_____________

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-04-07 14:37:38 Re: plperlu and perl 5.10
Previous Message Dan99 2008-04-07 13:51:26 Re: slow pgsql tables - need to vacuum?