As Andy mentioned. After tuning a query, every thing settled in . Now the
cpu utilization has come down a lot..
Thanks a lot for the help. I will certainly use the tool, pg_top
kind regards
On Fri, Apr 11, 2014 at 12:35 AM, Venkata Balaji Nagothi
wrote:
>
> On Thu, Apr 10, 2014 at 12:43 AM, Ba
On Thu, Apr 10, 2014 at 12:43 AM, Bala Venkat wrote:
> Hi all -
>
>We are running postgres 9.0 ( 32 bit ) + postgis 1.5.2 on Solaris
> Sparc M5000 with 64GB . Recently we are getting CPU utilitzation to 99% .
>
> In the config file
>
>
> shared_buffers=2GB.
> work_mem = 128MB
> effective
On 04/09/2014 09:43 AM, Bala Venkat wrote:
Hi all -
We are running postgres 9.0 ( 32 bit ) + postgis 1.5.2 on Solaris Sparc
M5000 with 64GB . Recently we are getting CPU utilitzation to 99% .
In the config file
shared_buffers=2GB.
work_mem = 128MB
effective_cache_size=48GB
maintainc
