Re: [GENERAL] Need help in tuning

2014-08-06 Thread David G Johnston
Phoenix Kiula wrote > My PG server is still going down. After spending the weekend doing a > CLUSTER of my largest table (it's a RAID 1 system with SATA hard disks > and 4 GB memory, mostly devoted to PG) I still have this issue. > > When I do a "top" command, 99% of the CPU and about 15% of the m

[GENERAL] Need help in tuning

2014-08-06 Thread Phoenix Kiula
My PG server is still going down. After spending the weekend doing a CLUSTER of my largest table (it's a RAID 1 system with SATA hard disks and 4 GB memory, mostly devoted to PG) I still have this issue. When I do a "top" command, 99% of the CPU and about 15% of the memory is being taken by PG. Wh