Please try to keep postings to one mailing list - I've replied to the
performance list here.
Shohab Abdullah wrote:
Dear,
We are facing performance tuning problem while using PostgreSQL Database
over the network on a linux OS.
Our Database consists of more than 500 tables with an average of 10K
records per table with an average of 20 users accessing the database
simultaneously over the network. Each table has indexes and we are
querying the database using Hibernate.
The biggest problem is while insertion, updating and fetching of records,
ie the database performance is very slow. It take a long time to respond
in the above scenario.
Please provide me with the tuning of the database. I am attaching my
postgresql.conf file for the reference of our current configuration
You haven't provided any details on what version of PG you are using,
what hardware you are using, whether there is a specific bottleneck
(disk, memory, cpu) or certain queries.
Without that, no-one can suggest useful settings. You might find this
document a good place to start: http://www.powerpostgresql.com/PerfList/
HTH
--
Richard Huxton
Archonet Ltd
