View Single Post

   
  #2 (permalink)  
Old 04-12-2008, 09:51 AM
Heikki Linnakangas
 
Posts: n/a
Default Re: Autovacuum versus rolled-back transactions

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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Reply With Quote