VACUUM ANALYZE is faster than ANALYZE?
From:
Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To:
PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:
VACUUM ANALYZE is faster than ANALYZE?
Date:
2012-02-21 14:00:00
Message-ID:
CAFj8pRAhJzS4xVTrB7CkuTE1gt2fgtaBEkiKo891poRUdTQYTA@mail.gmail.com (view raw or flat )
Thread:
2012-02-21 14:00:00 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2012-02-22 12:59:39 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-02-22 13:13:34 from Nicolas Barbier <nicolas(dot)barbier(at)gmail(dot)com>
2012-02-22 13:33:07 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-02-22 18:36:38 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2012-02-22 18:57:12 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2012-02-22 19:12:35 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2012-02-25 20:03:18 from Cédric Villemain <cedric(at)2ndquadrant(dot)fr>
2012-02-22 13:38:40 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-02-22 15:29:56 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-02-22 15:35:51 from "ktm(at)rice(dot)edu" <ktm(at)rice(dot)edu>
2012-02-22 17:54:41 from Jeroen Vermeulen <jtv(at)xs4all(dot)nl>
2012-02-22 19:23:10 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-02-22 22:02:43 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-02-23 08:34:18 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-02-23 14:44:12 from Robert Haas <robertmhaas(at)gmail(dot)com>
Lists:
pgsql-hackers
Hello
I had to reply to query about usage VACUUM ANALYZE or ANALYZE. I
expected so ANALYZE should be faster then VACUUM ANALYZE.
But is not true. Why?
Regards
Pavel Stehule
Responses
pgsql-hackers by date
Next :From: Simon RiggsDate: 2012-02-21 14:48:42Subject : Re: 16-bit page checksums for 9.2Previous :From : Etsuro FujitaDate : 2012-02-21 11:25:25Subject : Re: pgsql_fdw, FDW for PostgreSQL server
