Re: oddly slow query - Mailing list pgsql-general

From Pavel Stehule
Subject Re: oddly slow query
Date
Msg-id 162867790801111237p70ac9ed7vef85e707cf6714bf@mail.gmail.com
Whole thread Raw
In response to oddly slow query  (Jessi Berkelhammer <jberkelhammer@desc.org>)
List pgsql-general
On 11/01/2008, Jessi Berkelhammer <jberkelhammer@desc.org> wrote:
> Hello.
>
> I'm trying to figure out why a query I'm doing is incredibly slow (~10
> minutes.) The incredibly slow query is something like:
>
> SELECT count(*) from registration LEFT JOIN person USING (person_id)
> WHERE x_program(registration.x_type_code) = 'blah';

Hello

what do you do in x_program function? Are you sure so it is fast?

Regards
Pavel Stehule

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: oddly slow query
Next
From: Jessi Berkelhammer
Date:
Subject: Re: oddly slow query