Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL using 100% CPU - Mailing list pgsql-admin

From Emanuel Calvo Franco
Subject Re: PostgreSQL using 100% CPU
Date
Msg-id f205bb120907190947h53ec37aofc0e1022440c7f38@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL using 100% CPU  (rasa <openok@gmail.com>)
List pgsql-admin
Tree view 
>> 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

pgsql-admin by date:

Previous
From: mitra nazemian
Date:
Subject: implement ldap authentication in PostgreSQL
Next
From: Ibrahim Shaame
Date:
Subject: Cannot create UTF8 database