Re: Autovacuum versus rolled-back transactions

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Autovacuum versus rolled-back transactions
Дата
Msg-id 46581207.3060305@enterprisedb.com
обсуждение исходный текст
Ответ на Autovacuum versus rolled-back transactions  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Role privileges in PostgreSQL.
Следующее
От: Oleg Bartunov
Дата:
Сообщение: Re: Why not keeping positions in GIN?