Postgres Pro
Downloads
Home   >   mailing lists

select sql slow inside function - Mailing list pgsql-general

From Gary Fu
Subject select sql slow inside function
Date
Msg-id i6or2u$2s15$1@news.hub.org
Whole thread Raw
Responses Re: select sql slow inside function
List pgsql-general
Tree view 
Hi,

I have a function proc_TaskComplete that inserts a record to table
TaskHistory and then calls another function proc_ExportTaskComplete,
that will retrieve (select) the record just inserted based on an index
column (TaskId) in that table TaskHistory.  I noticed that the select
sql (inside proc_ExportTaskComplete) will take 3 seconds.  Under normal
condition (psql) the select sql is fast enough with the index. Can
anyone explain why and how to fix the problem ?
My postgresql version is 8.4.4

Thanks,
Gary

pgsql-general by date:

Previous
From: Julia Jacobson
Date:
Subject: Extracting data from BYTEA column to binary file using libpq
Next
From: "Daniel Verite"
Date:
Subject: Re: Extracting data from BYTEA column to binary file using libpq