Good Afternoon !!!The view executes very faster for the first time.When I execute the view again and again suddenly it gets slow or it gets hang.I have also traced the query plan but it changes for each execution.Can we fix the query plan.I have also tested the view on my test machine but the result was same.The view contains multi-table joins.Warm Regards,Suresh Borse On Thu, 2008-07-10 at 12:25 +0300, Julius Tuskenis wrote:
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
>
>