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