From: Richard Huxton <dev@archonet.com>
To: Shohab Abdullah <Shohab.Abdullah@lntinfotech.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Fw: PostgreSQL Performance Tuning
Date: Thu, 26 Apr 2007 12:53:32 +0100
Message-ID: <463092BC.60505@archonet.com> (raw)
In-Reply-To: <OFD8A57358.7B14EA49-ON652572C9.003FE2B7-652572C9.003FFA83@lntinfotech.com>
References: <OFD8A57358.7B14EA49-ON652572C9.003FE2B7-652572C9.003FFA83@lntinfotech.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dev@archonet.com, Shohab.Abdullah@lntinfotech.com
Subject: Re: Fw: PostgreSQL Performance Tuning
In-Reply-To: <463092BC.60505@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox