Re: Performance problem in PLPgSQL - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Performance problem in PLPgSQL
Date
Msg-id 352.1374588018@sss.pgh.pa.us
Whole thread Raw
In response to Performance problem in PLPgSQL  (Marc Cousin <cousinmarc@gmail.com>)
Responses Re: Performance problem in PLPgSQL
List pgsql-hackers
Marc Cousin <cousinmarc@gmail.com> writes:
> The example below is of course extremely simplified, and obviously not
> what we are really doing in the database, but it exhibits the slowdown
> between 9.1.9 and 9.2.4.

Hm.  Some experimentation shows that the plan cache is failing to switch
to a generic plan, but I'm not sure why the cast would have anything to
do with that ...
        regards, tom lane



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: make --silent
Next
From: Greg Stark
Date:
Subject: Re: Bloom Filter lookup for hash joins