Message-ID: <4875D589.1030107@nsoft.lt>
Date: Thu, 10 Jul 2008 12:25:29 +0300
From: Julius Tuskenis <julius@nsoft.lt>
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
To: s.borse@direction.biz
CC: pgsql-admin@postgresql.org
Subject: Re: query optimization
References: <1215680493.2113.26.camel@dss-052.dsslp.com>
In-Reply-To: <1215680493.2113.26.camel@dss-052.dsslp.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

Hello, Suresh

Maybe its taking long for the first time, and then its faster? Did you 
noticed any circumstances under witch your query takes longer to execute?


Suresh Borse rašė:
> 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
>
>


-- 
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050