Achilleus,
> i think i have an issue regarding the statistics that
> a) (plain) ANALYZE status and
> b) VACUUM ANALYZE status
> produce.
It's perfectly normal for a query to run faster after a VACUUM ANALYZE than
after an ANALYZE ... after all, you just vacuumed it, didn't you?
If you're demonstrating some other kind of behavioural difference, then please
post the results of EXPLAIN ANALYZE for the two examples.
Oh, and we should probably shift this discussion to the PGSQL-PERFORMANCE
list.
--
Josh Berkus
Aglio Database Solutions
San Francisco