Skip site navigation (1) Skip section navigation (2)

Re: Fw: PostgreSQL Performance Tuning

From: Gerhard Wiesinger <lists(at)wiesinger(dot)com>
To: Shohab Abdullah <Shohab(dot)Abdullah(at)lntinfotech(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org
Subject: Re: Fw: PostgreSQL Performance Tuning
Date: 2007-04-26 17:02:36
Message-ID: Pine.LNX.4.64.0704261857480.12380@bbs.intern (view raw, whole thread or download thread mbox)
Lists: pgsql-generalpgsql-performance

I would do the following (in that order):
1.) Check for a performant application logic and application design (e.g. 
degree of granularity of the Java Hibernate Mapping, are there some 
object iterators with hundreds of objects, etc.)
2.) Check the hibernate generated queries and whether the query is 
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.



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 :
> ÿÿI cannot predict future, I cannot change past, I have just the present
> 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.
> ______________________________________________________________________

In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2007-04-26 17:49:32
Subject: Re: Filesystem fragmentation (Re: Fragmentation of WAL files)
Previous:From: Leif B. KristensenDate: 2007-04-26 16:55:42
Subject: Re: Feature request - have postgresql log warning when new sub-release comes out.

pgsql-general by date

Next:From: John D. BurgerDate: 2007-04-26 17:22:18
Subject: DIfferent plans for explicit versus implicit join using link table
Previous:From: Leif B. KristensenDate: 2007-04-26 16:55:42
Subject: Re: Feature request - have postgresql log warning when new sub-release comes out.

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group