Re: Postgres is using 100% CPU

From: Ashik S L <ashiksl178(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres is using 100% CPU
Date: 2015-05-30 13:46:24
Message-ID: CAC=-3Dc6RhLgCqO4sNscOQFT0TybVNHciPdvFEwfhvK0Ta3YMw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-performance

We are using postgres SQL version 8.4.17..
Postgres DB szie is 900 MB and we are inserting 273 rows at once .and
each row is of 60 bytes.Every time we insert 16380 bytes of data.
I tried to make some config changes using above link. But I did not
see any improvement.
I made following changes in postgres.conf file:
shared_buffers = 512MB // It was 32MB
work_mem = 30MB
effective_cache_size = 512MB // I tried with 128MB 256MB also

Please let me know any config changes that I can try out.

Thanks,
Ashik

On 5/30/15, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> wrote:
>
>
> On 05/29/15 20:10, Ashik S L wrote:
>> Hi All,
>>
>> I am using postgresDB on redhat machine which is having 4GB RAM
>> machine. As soon as it starts to Inserting rows into the postgres DB
>> it will reach 100%cpu. It will comedown to normal after 40 minutes. I
>> tried perform some tuning on the postgres DB, But result was same.I
>> am not postgres DB expert. Even we are not seeing in all machine.
>> Only few machines we are seeing this issue. Any help on this would
>> be appreciated.
>
> Ashik, before pointing you to this list, I asked for some basic
> information that are needed when diagnosing issues like this - database
> size, postgres version etc. We can't really help you without this info,
> because right now we only know you're doing some inserts (while before
> you mentioned updates), and it's slow.
>
> Also, can you please provide info about the configuration and what
> changes have you done when tuning it?
>
> Have you seen this?
>
> https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
>
> regards
>
> --
> Tomas Vondra http://www.2ndQuadrant.com
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
>
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tomas Vondra 2015-05-30 14:20:32 Re: Postgres is using 100% CPU
Previous Message gc.carrai 2015-05-30 06:29:35 BUG #13379: error installing

Browse pgsql-performance by date

  From Date Subject
Next Message Tomas Vondra 2015-05-30 14:20:32 Re: Postgres is using 100% CPU
Previous Message Tomas Vondra 2015-05-29 23:47:49 Re: Different plan for very similar queries