0006620: Turn on UNLOGGED table mode during initial load into an empty PostgreSQL table - SymmetricDS

Summary	0006620: Turn on UNLOGGED table mode during initial load into an empty PostgreSQL table

Revision	2024-10-15 11:34 by pbelov
Additional Information	The drawback of the UNLOGGED mode is that the contents of such table are also not replicated (to standby PostgreSQL servers). This mode is specific to PostgreSQL database and is not present in ANSI/ISO specification. Oracle database has a similar table-level mode called NO LOGGING, but only applies to the insert statement with the /+ APPEND / hint or SQL*Loader. The parents database ARCHIVELOG / NO ARCHIVE LOG configuration is also important in Oracle, but not in PostgreSQL.

Revision	2024-10-15 11:03 by pbelov
Additional Information	The drawback of the UNLOGGED mode is that the contents of such table are also not replicated (to standby PostgreSQL servers). This mode is specific to PostgreSQL database and is not present in ANSI/ISO specification. Oracle database has a similar table-level mode called NO LOGGING, but only applies to the insert statement with the /+ APPEND / hint.