PostgreSQL using 100% CPU

From: rasa <openok(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: PostgreSQL using 100% CPU
Date: 2009-07-16 09:00:01
Message-ID: 1df20170907160200nd9c06eeu4602bfabade2c4b7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi, All!

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.

--
With best wishes, Rooslan.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andreas Wenk 2009-07-16 09:14:19 Re: Where 8.4.0 binaries-no-installer for win32
Previous Message Abraham, Danny 2009-07-16 08:11:06 Re: initdb --encoding=LATIN1 fails on Windows