From: | Suresh Borse <s(dot)borse(at)direction(dot)biz> |
---|---|
To: | Julius Tuskenis <julius(at)nsoft(dot)lt> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: query optimization |
Date: | 2008-07-10 09:45:44 |
Message-ID: | 1215683144.2113.35.camel@dss-052.dsslp.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
> >
> >
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Julius Tuskenis | 2008-07-10 10:39:05 | Re: query optimization |
Previous Message | Dev | 2008-07-10 09:31:09 | Re: create role syntax |