Re: query optimization

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