| 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-16 13:53:48 |
| Message-ID: | f205bb120907160653p10857e5bsb6332ce61cb5114@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.
>
Try to get this data:
select * from pg_stat_activity; (shows you the backends running)
With this try to detect if a query is hang on the server.
Could be some problems in the I/O,too.
--
Emanuel Calvo Franco
www.emanuelcalvofranco.com.ar
ArPug.com.ar / aosug.com.ar
| From | Date | Subject | |
|---|---|---|---|
| Next Message | J. Carlos Muro | 2009-07-16 15:27:27 | Tests with switch of WAL segment files. |
| Previous Message | Andreas Wenk | 2009-07-16 09:14:19 | Re: Where 8.4.0 binaries-no-installer for win32 |