Postgres Pro
Downloads
Home   >   mailing lists

Query is slow when executing in procedure - Mailing list pgsql-performance

From ramasubramanian
Subject Query is slow when executing in procedure
Date
Msg-id 734E023A56D3403BB6FB96ABBE265337@ramasubramanian
Whole thread Raw
Responses Re: Query is slow when executing in procedure
Re: Query is slow when executing in procedure
List pgsql-performance
Tree view
Dear all,
    The query is slow when executing in the stored procedure(it is taking around 1 minute). when executing as a sql it is taking 4 seconds.
basically i am selecting the varchar column which contain 4000 character. We have as iindex on the table. We have analyzed the table also. What could be the reason. How to improve it?
 
Thanks in Advance
Ram

pgsql-performance by date:

Previous
From: Faheem Mitha
Date:
Subject: Re: query optimization
Next
From: Pavel Stehule
Date:
Subject: Re: Query is slow when executing in procedure