Re: UDF in C slow - Mailing list pgsql-general

From Tom Lane
Subject Re: UDF in C slow
Date
Msg-id 5875.1336751723@sss.pgh.pa.us
Whole thread Raw
In response to Re: UDF in C slow  (Inanc Seylan <inanc.seylan@gmail.com>)
Responses Re: UDF in C slow
List pgsql-general
Inanc Seylan <inanc.seylan@gmail.com> writes:
> It is IMMUTABLE. I attach the output of EXPLAIN both with and without
> the simple function (returning true only) in the query.

EXPLAIN ANALYZE would have been far more helpful.  However, the thing
that jumps out at me here is all the seqscans on table "symbols".
Do you not have an index on symbols.id?  If you do, perhaps there is
a datatype-mismatch problem preventing it from being used.

            regards, tom lane

pgsql-general by date:

Previous
From: "Vo, Catherine CTR DTIC Z"
Date:
Subject: backup script
Next
From: Inanc Seylan
Date:
Subject: Re: UDF in C slow