Re: Postgresq 8,1 hangs when running function

From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
To: ben sewell <mosherben(at)gmail(dot)com>, Michael Fuhr <mike(at)fuhr(dot)org>, <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Postgresq 8,1 hangs when running function
Date: 2006-08-21 14:08:24
Message-ID: C10F3698.FD3A%sdavis2@mail.nih.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On 8/21/06 9:31 AM, "ben sewell" <mosherben(at)gmail(dot)com> wrote:

> Hi guys, thanks for the tips. Yup I ran the query with the joins in this
> time. Explain analyze returned 68 rows this time, in 570 MS. Is the MS time
> normal?

Explain analyze will return the time to complete the query, along with times
for sub-parts of the query. There is no "normal", as it depends on the
complexity of the query, as well as tuning, etc. But 570 ms is 1/2 of one
second, which is probably acceptible.

> ok now I seem to be getting somewhere, inputting stuff into my function and
> now it's saying returned record type does not match expected record type,
> even thorugh I give the types of the fields in the query. Any ideas? I've
> checked the fields I am expecting to be returned against what they are
> stored as in the DB and there are nothing different.

When you actually run the SQL (outside of the function), what is returned?
How does THAT compare to what you asked for?

Sean

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Fuhr 2006-08-21 14:30:19 Re: Postgresq 8,1 hangs when running function
Previous Message Tom Lane 2006-08-21 13:58:38 Re: Postgresq 8,1 hangs when running function