Post reply

UNLOGGED Tables in PostgreSQL: When Speed Matters More Than Durability

  • November 21, 2025 at 12:00 am

    #4680967

    Comments posted to this topic are about the item UNLOGGED Tables in PostgreSQL: When Speed Matters More Than Durability

  • November 21, 2025 at 7:20 am

    #4688403

    MSSQL has a similar function, but at the DB level, so we have an associated database to the main one, which contains something like logs and performance monitor data.

    Settings: ALTER DATABASE DatabaseName SET DELAYED_DURABILITY = DISABLED;

  • November 21, 2025 at 9:35 pm

    #4688657

    Delayed durability function still doesn't match exactly the postgres UNLOGGED functionality. The log entries are still created and eventually flushed to the disk.

  • November 22, 2025 at 9:33 am

    #4688828

    petr.novak wrote:

    MSSQL has a similar function, but at the DB level, so we have an associated database to the main one, which contains something like logs and performance monitor data. Settings: ALTER DATABASE DatabaseName SET DELAYED_DURABILITY = DISABLED;

    This means the total opposite of unlogged. Log entries are written to disk in a synchronized fashion , instead of in batches periodically.

    ----------------------------------------------------

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply