Re: Temporary tables and disk activity

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Temporary tables and disk activity
Дата
Msg-id 28666.1102976696@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Temporary tables and disk activity  (Phil Endecott <spam_from_postgresql_general@chezphil.org>)
Список pgsql-general
Phil Endecott <spam_from_postgresql_general@chezphil.org> writes:
> What would happen if I were to rollback at the end of the transaction,
> rather than committing (having made no changes)?  Would that eliminate
> some or all of the catalog writes?

It would avoid fsync'ing the changes at commit time, but not really
reduce the write volume per se.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Possible dump/restore bug
Следующее
От: William Yu
Дата:
Сообщение: Re: Possible dump/restore bug