Re: [PERFORM] %100 CPU on Windows Server 2003

2011-04-25 Thread Robert Haas
On Wed, Apr 20, 2011 at 10:55 AM, Allen Sooredoo < allen_soore...@carrefour.com> wrote: > Hi, > we are facing a performance issue on Postgres 8.4, the CPU reaches 100% > with less than 50 simultaneous users. > > We were thinking to migrate the HR system from Oracle to Postgres but now > that we ha

Re: [PERFORM] %100 CPU on Windows Server 2003

2011-04-20 Thread Pavel Stehule
Hello please, can you attach a value of shadow_buffers and work_mem from config file? Windows are very sensitive on memory setting. There must be lot of memory just for MS Windows. Regards Pavel Stehule 2011/4/20 Allen Sooredoo > Hi, > we are facing a performance issue on Postgres 8.4, the C

[PERFORM] %100 CPU on Windows Server 2003

2011-04-20 Thread Allen Sooredoo
Hi, we are facing a performance issue on Postgres 8.4, the CPU reaches 100% with less than 50 simultaneous users. We were thinking to migrate the HR system from Oracle to Postgres but now that we have those big performance problems on relatively small applications, we are questioning this choic