"Allen Sooredoo" <allen_soore...@carrefour.com> wrote: > 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? Since many people are using PostgreSQL with large databases and many users, it's important to understand what it is about your particular situation which is causing it not to perform well. (Our shop, for example, has a 2 TB database with millions of hits per day.) Please read this and post to the pgsql-performance list: http://wiki.postgresql.org/wiki/SlowQueryQuestions You will probably get the most useful responses if you can first identify one or more of your slow queries and post the specifics of those, per the above web page. -Kevin
-- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
