select updates pg_stat_database

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема select updates pg_stat_database
Дата
Msg-id 1155583862.11726.50.camel@dogma.v10.wvs
обсуждение исходный текст
Ответы Re: select updates pg_stat_database
Список pgsql-general
I have noticed that all SELECT queries alone in a transaction also
update pg_stat_database (I know it's just a view that calls
pg_stat_get_db_xact_commit()).

Does that mean that SELECTs by themselves require a disk write? If so,
is that a synchronous disk write? Is it due to something else entirely
(like autovacuum or the statistics collector)?

Also, is there a way to retrieve the current transaction id?

Thanks,
    Jeff Davis


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

Предыдущее
От: Scott Ribe
Дата:
Сообщение: Re: Best approach for a "gap-less" sequence
Следующее
От: Tom Lane
Дата:
Сообщение: Re: text datum VARDATA and strings