Skip site navigation (1) Skip section navigation (2)

Re: query optimization

From: Julius Tuskenis <julius(at)nsoft(dot)lt>
To: s(dot)borse(at)direction(dot)biz
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: query optimization
Date: 2008-07-10 09:25:29
Message-ID: 4875D589.1030107@nsoft.lt (view raw or flat)
Thread:
Lists: pgsql-admin
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


In response to

Responses

pgsql-admin by date

Next:From: DevDate: 2008-07-10 09:31:09
Subject: Re: create role syntax
Previous:From: Suresh BorseDate: 2008-07-10 09:01:33
Subject: query optimization

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group