Hi Jeff,
Thanks for your reply.
Yes, it took a while to complete the autovacuum.
I checked it again this morning:
last_autovacuum: 2013-04-14 06:17:02.9464+08
last_autoanalyze: 2013-04-13 20:27:12.396048+08
n_dead_tup: nill (or blank)
n_live_tup: 334453396
relpages: 2654868
reltuples: 3.3
On Sat, Apr 13, 2013 at 9:55 AM, Ascot Moss wrote:
>
> Current stat of "test" table:
> pg_class.reltuples: 3.8415e+08
> pg_class.relpages: 1703069
> last_autovacuum: null (or blank)
> last_autoanalyze: 2013-04-13 20:27:12.396048+08
> pg_stat_user_tables.n_dead_tup: 3
>
> The autovacuum th
