Re: vacuum analyze slows sql query

patrick ~ <sidsrr@yahoo.com> writes:
>  PREPARE pkk_00 ( integer ) <the def of pkk_offer_has_pending_purc( integer )

This is what you want to do, but not quite like that.  The PREPARE
determines the plan and so VACUUMing and re-EXECUTing is going to show
the same plan.  What we need to look at is
    - standing start
    PREPARE pkk_00 ...
    EXPLAIN ANALYZE EXECUTE pkk_00 ...
    VACUUM ANALYZE;
    PREPARE pkk_01 ...
    EXPLAIN ANALYZE EXECUTE pkk_01 ...

            regards, tom lane