On Saturday, April 13, 2013, Ascot Moss wrote:
> 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
>
> ...
>
>
> I also
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
Hi,
I am new to PostgreSQL.
I have a PostgreSQL table named "test" with 300,000,000 records inserted,
it has only two fields (id, and int i). For testing purposes, after
inserts, all records have been updated once in order to make n_dead_tup =
300,000,000
Current PostgreSQL settings:
autovacuum
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
(please ignore if duplicated)
Hi,
I am new to PostgreSQL.
I have a PostgreSQL table named "test" with 300,000,000 records inserted,
it has only two fields (id, and int i). For testing purposes, after
inserts, all records have been updated once in order to make n_dead_tup =
300,000,000
Current
