Re: PostgreSQL using 100% CPU

From: Emanuel Calvo Franco <postgres(dot)arg(at)gmail(dot)com>
To: rasa <openok(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: PostgreSQL using 100% CPU
Date: 2009-07-19 16:47:34
Message-ID: f205bb120907190947h53ec37aofc0e1022440c7f38@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

>> I migrate from Win/MSSQL to FC/PostgreSQL. After month of work on fedora
>> postgresql server, accounters can't calculate one form. I detect, that
>> postgres process use a 100% of CPU.
>> How solve this problem? Thanks a lot.
>> 2 CPU, 4 Gb RAM, 2x250 Gb (229 Gb free), autovacuum is on.
>

What's saying select pg_stat_sctivity() ?
You have able statistiscs?

--
Emanuel Calvo Franco
www.emanuelcalvofranco.com.ar
ArPug.com.ar / aosug.com.ar

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ibrahim Shaame 2009-07-20 07:42:10 Cannot create UTF8 database
Previous Message mitra nazemian 2009-07-19 07:19:48 implement ldap authentication in PostgreSQL