Re: [PERFORM] about performance of postgreSQL

2003-08-14 Thread Josh Berkus
Xin, > I would recomment trying to take a close look at many of the posts on > the Performance list (searching the archives) and paying attention to > things such as effective_cache_size and shared_buffers. If these don't > answer your questions, ask this list again. Also see these articles: http

[PERFORM] about performance of postgreSQL

2003-08-14 Thread xin fu
Dear master:    I have learned postgreSQL for serveral days, now i meet some problems. when I use a TPCC(Transaction Processing Performance Council) test program to test the performance of postgreSQL , postgreSQL works very slowly, it almost need 1 minute to finish a transaction, and the CPU pe

Re: [PERFORM] about performance of postgreSQL

2003-08-14 Thread Chris Travers
Hi Xin; PostgreSQL is configured to run on virutally anything out of the box. The reason for this is that, like Oracle, the database manager will not start if it cannot allocate sufficient resources. We take the approach of ensuring that it will start so you can tune it. I would recomment trying