Re: severe performance issue with planner - Mailing list pgsql-performance

> if i first do prepare blah as SELECT ....., then run execute blah, the
> time goes down to about 275ms  (i had been running this query a lot, and
> did a vacuum update before all this).

If you make it an SQL stored procedure, you get the speed up of the
PREPARE command, without having to prepare manually all the time.

Chris