Re: PostgreSQL using 100% CPU

>  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