Date: Thu, 26 Apr 2007 19:02:36 +0200 (CEST)
From: Gerhard Wiesinger <lists@wiesinger.com>
To: Shohab Abdullah <Shohab.Abdullah@lntinfotech.com>
Cc: pgsql-general@postgresql.org, pgsql-performance@postgresql.org
Subject: Re: Fw: PostgreSQL Performance Tuning
In-Reply-To: 
 <OFD8A57358.7B14EA49-ON652572C9.003FE2B7-652572C9.003FFA83@lntinfotech.com>
Message-ID: <Pine.LNX.4.64.0704261857480.12380@bbs.intern>
References: 
 <OFD8A57358.7B14EA49-ON652572C9.003FE2B7-652572C9.003FFA83@lntinfotech.com>
MIME-Version: 1.0
X-MailScanner-Information-wiesinger.com: Please contact the ISP for more
	information
X-MailScanner-wiesinger.com: Found to be clean
X-MailScanner-SpamCheck-wiesinger.com: not spam, SpamAssassin (score=-1.44,
	required 4.5, autolearn=not spam, ALL_TRUSTED -1.44)
X-MailScanner-From: lists@wiesinger.com
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.293 tagged_above=0 required=5 tests=AWL=0.343,
	BAYES_40=-0.185, FORGED_RCVD_HELO=0.135
X-Spam-Level: 
Content-Type: TEXT/PLAIN; charset=iso-8859-1; format=flowed
Content-Transfer-Encoding: QUOTED-PRINTABLE
X-Archive-Number: 200704/1136
X-Sequence-Number: 113039

Hello!

I would do the following (in that order):
1.) Check for a performant application logic and application design (e.g.=
=20
degree of granularity of the Java Hibernate Mapping, are there some=20
object iterators with hundreds of objects, etc.)
2.) Check the hibernate generated queries and whether the query is=20
suitable or not. Also do a "explain query" do see the query plan.

Sometimes a manually generated is much more efficient than hibernate ones.

3.) Optimize the database e.g. postgresql.

Ciao,
Gerhard

--
http://www.wiesinger.com/


On Thu, 26 Apr 2007, 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
>
>
>
> Please replay me ASAP
> Regards,
>   Shohab Abdullah
>   Software Engineer,
>    Manufacturing SBU-POWAI
>    Larsen and Toubro Infotech Ltd.| 4th floor, L&T Technology Centre,
> Saki Vihar Road, Powai, Mumbai-400072
>      (:  +91-22-67767366 | (:  +91-9870247322
>        Visit us at : http://www.lntinfotech.com
> =FF=FFI cannot predict future, I cannot change past, I have just the pres=
ent
> moment, I must treat it as my last"
> -------------------------------------------------------------------------=
---------------
> The information contained in this email has been classified:
> [ X] L&T Infotech General Business
> [    ] L&T Infotech Internal Use Only
> [    ] L&T Infotech Confidential
> [    ] L&T Infotech Proprietary
> This e-mail and any files transmitted with it are for the sole use of the
> intended recipient(s) and may contain confidential and privileged
> information.
> If you are not the intended recipient, please contact the sender by reply
> e-mail and destroy all copies of the original message.
>
> ______________________________________________________________________
>=