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: (view raw, whole thread or download thread mbox)
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


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-2017 The PostgreSQL Global Development Group