High CPU usage and lag

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

High CPU usage and lag

Postby Memphis213 » Wed May 21, 2008 12:41 am

PostgreSQL is taking up 50% of my CPU and pokertracker is taking over 19% and this is idling. Not importing even. On multiple occasions I have also found 7 or 8 of the process running at once. I am on vista machine. It makes my computer unusable.
Memphis213
 
Posts: 7
Joined: Sun May 11, 2008 5:46 pm

Re: High CPU usage and lag

Postby prajna » Wed May 21, 2008 3:59 am

The multiple processes are supposed to happen. Its how a server works in this case. As for the processor time, please regularly cluster and vacuum your database.

~ Thomas
[Pokertracker support]
prajna
 
Posts: 734
Joined: Thu Apr 03, 2008 1:58 pm

Re: High CPU usage and lag

Postby xghjase » Wed May 21, 2008 4:35 am

I have a top of the range PC (E6750, 2gb ram) and am running XP and postgres lags the shit out of my computer.
I can't play any games because my fps drops below 30 when it usually runs at a smooth 100.
How can I prevent this?
xghjase
 
Posts: 9
Joined: Sun Mar 23, 2008 8:27 am

Re: High CPU usage and lag

Postby WhiteRider » Wed May 21, 2008 12:21 pm

I guess you could try stopping the postgres service while you are gaming.
Start -> Programs -> Postgres -> Stop Service
(and start it again when you want to run PT3)
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 23 guests

cron