Request a Demo
Home   >   mailing lists

query optimization - Mailing list pgsql-admin

From Suresh Borse
Subject query optimization
Date
Msg-id 1215680493.2113.26.camel@dss-052.dsslp.com
Whole thread Raw
Responses Re: query optimization
List pgsql-admin
Tree view
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


pgsql-admin by date:

Previous
From: Dev
Date:
Subject: create role syntax
Next
From: Julius Tuskenis
Date:
Subject: Re: query optimization