Re: %100 CPU on Windows Server 2003 - Mailing list pgsql-performance
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
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@carrefour.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?
RegardsThis 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
pgsql-performance by date: