Re: [PERFORM] Throttling PostgreSQL's CPU usage

2007-05-09 Thread Daniel Griscom
Thanks again for all the feedback. Running on a dual processor/core machine is clearly a first step, and I'll look into the other suggestions as well. Thanks, Dan -- Daniel T. Griscom [EMAIL PROTECTED] Suitable Systems http://www.suitable.com/ 1 Centre Street, Suite 2

Re: [PERFORM] Throttling PostgreSQL's CPU usage

2007-05-08 Thread Daniel Griscom
Thanks for all the feedback. Unfortunately I didn't specify that this is running on a WinXP machine (the 3D renderer is an ActiveX plugin), and I don't even think "nice" is available. I've tried using the Windows Task Manager to set every postgres.exe process to a low priority, but that didn't

[PERFORM] Throttling PostgreSQL's CPU usage

2007-05-08 Thread Daniel Griscom
I'm building a kiosk with a 3D front end accessing PostGIS/PostgreSQL via Apache/PHP. The 3D display is supposed to show smooth motion from location to location, with PostGIS giving dynamically updated information on the locations. Everything runs on the same machine, and it all works, but when