Re: Autovacuum versus rolled-back transactions - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Autovacuum versus rolled-back transactions
Date
Msg-id 46581207.3060305@enterprisedb.com
Whole thread Raw
In response to Autovacuum versus rolled-back transactions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> I'm kind of leaning to the separate-tally method and abandoning the
> assumption that the identities hold.  I'm not wedded to the idea
> though.  Any thoughts?

That seems like the best approach to me. Like the scan/fetch counters, 
n_tup_ins and n_tup_del represent work done regardless of 
commit/rollback, but n_live_tup and n_dead_tup represent the current 
state of the table.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Role privileges in PostgreSQL.
Next
From: Oleg Bartunov
Date:
Subject: Re: Why not keeping positions in GIN?