Re: Fw: PostgreSQL Performance Tuning

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