On 8/2/2014 6:20 PM, Phoenix Kiula wrote:
PS: CentOS 6 64 bit, 4 GB of RAM, Raid 1 Raptor disks. Postgresql.conf
and TOP output during the running of the REINDEX are below..
----POSTGRESQL.CONF-----
max_connections = 180
superuser_reserved_connections = 5
shared_buffers = 512MB
effective_cache_size = 1200MB
temp_buffers = 32MB
maintenance_work_mem = 320MB
work_mem = 128MB
with 4GB of ram, and 180 connections, if you actually had all 180
connections busy at once, you could use over 180 times work_mem,
180*128MB in 4GB would be fatal.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
