Re: pg_autovacuum: short, wide tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_autovacuum: short, wide tables
Дата
Msg-id 24129.1120842032@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_autovacuum: short, wide tables  ("Matthew T. O'Connor" <matthew@zeut.net>)
Ответы Re: pg_autovacuum: short, wide tables  ("Matthew T. O'Connor" <matthew@zeut.net>)
Список pgsql-bugs
"Matthew T. O'Connor" <matthew@zeut.net> writes:
> Shouldn't the update to the toast table just be considered an update to
> table t1?  The fact that there is an underlying  toast table is an
> implementation detail that I don't think should show up in the stats system.

At the level of the stats system, though, you are interested in
"implementation details".  The fact that there is such a concept as an
index is an implementation detail according to the SQL standard --- but
if we hid that we wouldn't be able to show things that people want to
know.

In particular, I think people would like to be able to use the stats
views to see how much toast-related I/O is going on, and not have that
smushed together with main-table I/O.

            regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_autovacuum: short, wide tables
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_autovacuum: short, wide tables