Postgres Pro
Downloads
Home   >   mailing lists

Re: vacuum analyze slows sql query - Mailing list pgsql-performance

From Tom Lane
Subject Re: vacuum analyze slows sql query
Date
Msg-id 26773.1099723138@sss.pgh.pa.us
Whole thread Raw
In response to Re: vacuum analyze slows sql query  (patrick ~ <sidsrr@yahoo.com>)
Responses Re: vacuum analyze slows sql query
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: patrick ~
Date:
Subject: Re: vacuum analyze slows sql query
Next
From: Allen Landsidel
Date:
Subject: Re: Strange (?) Index behavior?