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_soore...@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? > > 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 * >
