Does TRUNCATE emit changes with REPLICA IDENTITY FULL?

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема Does TRUNCATE emit changes with REPLICA IDENTITY FULL?
Дата
Msg-id 157346399242.14265.3138867514991013615@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: Does TRUNCATE emit changes with REPLICA IDENTITY FULL?  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/11/sql-truncate.html
Description:

Hi,

The documentation says that TRUNCATE ignores ON DELETE triggers, but it
doesn't explicitly mention what happens if we use `wal_level = logical` and
`REPLICA IDENTITY FULL`. Does TRUNCATE emit changes for each row and clog
the WAL, or will it still be blazing fast?

Kind Regards,,
m.

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

Предыдущее
От: Brian Williams
Дата:
Сообщение: Re: The word "virgin" used incorrectly and probably better offreplaced
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: The word "virgin" used incorrectly and probably better offreplaced