Re: [ADMIN] PostgreSQL using 100% CPU

2009-07-19 Thread Emanuel Calvo Franco
>> 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

Re: [ADMIN] PostgreSQL using 100% CPU

2009-07-17 Thread rasa
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. >

Re: [ADMIN] PostgreSQL using 100% CPU

2009-07-16 Thread Scott Marlowe
On Thu, Jul 16, 2009 at 3:00 AM, rasa wrote: > 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

Re: [ADMIN] PostgreSQL using 100% CPU

2009-07-16 Thread Emanuel Calvo Franco
>  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 t

[ADMIN] PostgreSQL using 100% CPU

2009-07-16 Thread rasa
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