> 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