Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 7D84F65050C
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Thu, 10 Jul 2008 06:12:34 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 07725-05 for <pgsql-admin-postgresql.org@postgresql.org>;
	Thu, 10 Jul 2008 06:12:25 -0300 (ADT)
X-Greylist: delayed 00:06:38.598846 by SQLgrey-1.7.6
Received: from ns1.aaaonlinux.net (NS1.AAAONLINUX.net [70.84.189.18])
	by postgresql.org (Postfix) with ESMTP id 4D7A265032E
	for <pgsql-admin@postgresql.org>; Thu, 10 Jul 2008 06:12:28 -0300 (ADT)
Received: (qmail 25752 invoked by uid 508); 10 Jul 2008 09:11:12 -0000
Received: from unknown (HELO direction.biz) (59.163.21.147)
	by ns1.aaaonlinux.net with SMTP; 10 Jul 2008 09:11:12 -0000
Received: from [172.16.2.20] ([172.16.2.20])
	(authenticated user s.borse@direction.biz)
	by direction.biz (direction.biz) (MDaemon PRO v9.0.0)
	with ESMTP id md50001972541.msg
	for <pgsql-admin@postgresql.org>; Thu, 10 Jul 2008 14:33:56 +0530
Subject: query optimization
From: Suresh Borse <s.borse@direction.biz>
Reply-To: s.borse@direction.biz
To: pgsql-admin@postgresql.org
Content-Type: multipart/alternative; boundary="=-muCmwfxQFEheGbnwD5h1"
Organization: DSS
Date: Thu, 10 Jul 2008 14:31:33 +0530
Message-Id: <1215680493.2113.26.camel@dss-052.dsslp.com>
Mime-Version: 1.0
X-Mailer: Evolution 2.10.3 (2.10.3-9.fc7) 
X-Authenticated-Sender: s.borse@direction.biz
X-Spam-Processed: direction.biz, Thu, 10 Jul 2008 14:33:56 +0530
	(not processed: spam filter heuristic analysis disabled)
X-MDRemoteIP: 172.16.2.20
X-Return-Path: s.borse@direction.biz
X-MDaemon-Deliver-To: pgsql-admin@postgresql.org
X-MDAV-Processed: direction.biz, Thu, 10 Jul 2008 14:33:57 +0530
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.269 tagged_above=0 required=5 tests=AWL=0.268,
	HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200807/98
X-Sequence-Number: 29708


--=-muCmwfxQFEheGbnwD5h1
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

Dear All,

I am facing very strange problem in postgres while executing the view.

When I execute the view some times it takes few milliseconds, sometimes
it take several seconds and some times doesn't execute.

I tried to troubleshoot using the explain plan method. But explain plan
also changes for each execution.

Can anybody help me for troubleshooting  and for resolving the
performance issue.


Thanks & Regards,
Suresh Borse



--=-muCmwfxQFEheGbnwD5h1
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
  <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
  <META NAME="GENERATOR" CONTENT="GtkHTML/3.14.1">
</HEAD>
<BODY>
<FONT SIZE="2">Dear All,</FONT><BR>
<BR>
<FONT SIZE="2">I am facing very strange problem in postgres while executing the view.</FONT><BR>
<BR>
<FONT SIZE="2">When I execute the view some times it takes few milliseconds, sometimes it take several seconds and some times doesn't execute.</FONT><BR>
<BR>
<FONT SIZE="2">I tried to troubleshoot using the explain plan method. But explain plan also changes for each execution.</FONT><BR>
<BR>
<FONT SIZE="2">Can anybody help me for troubleshooting&nbsp; and for resolving the performance issue.</FONT><BR>
<BR>
<BR>
<FONT SIZE="2">Thanks &amp; Regards,</FONT><BR>
<FONT SIZE="2">Suresh Borse</FONT><BR>
<BR>
<BR>
</BODY>
</HTML>

--=-muCmwfxQFEheGbnwD5h1--