Re: %100 CPU on Windows Server 2003

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 <Allen_Sooredoo(at)carrefour(dot)com>

> 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 choice.
>
> The machine configuration, dedicated to Postgres is as follow:
> RAM: 3GB
> CPU: Intel Xeon CPU 3.2 Ghz
>
> Could you please provide us some support regarding this issue?
>
> Regards
>
>
>
> *This e-mail and any attachment are confidential and intended solely for
> the use of the individual to whom it is addressed. If you are not the
> intended recipient, please telephone or email the sender and delete this
> message and any attachment from your system. Unauthorized publication, use,
> dissemination, forwarding, printing or copying of this e-mail and its
> associated attachments is strictly prohibited.
> http://disclaimer.carrefour.com
> Let's respect the environment together. Only print this message if
> necessary *
>