Does TRUNCATE emit changes with REPLICA IDENTITY FULL?
PG Doc comments form <[email protected]> Mon, 11 Nov 2019 09:19:52 +0000
| Newsgroups | gmane.comp.db.postgresql.devel.documentation |
|---|---|
| Message-ID | <[email protected]> |
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.