Re: Reindex taking forever, and 99% CPU

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