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
