From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: nilsocket@gmail.com
Subject: Ambiguos statement in wal-async-commit page
Date: Mon, 13 Apr 2020 21:11:30 +0000
Message-ID: <158681229064.25695.12299508971635249207@wrigleys.postgresql.org> (raw)
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/wal-async-commit.html
Description:
In this page:
https://www.postgresql.org/docs/current/wal-async-commit.html
In this paragraph:
Certain utility commands, for instance DROP TABLE, are forced to commit
synchronously regardless of the setting of synchronous_commit. This is to
ensure consistency between the server's file system and the logical state of
the database. The commands supporting two-phase commit, such as PREPARE
TRANSACTION, are also always synchronous.
> This is to ensure consistency between the server's file system and the
logical state of the database.
Here I don't understand how inconsistency is introduced, if DROP TABLE or
PREPARE transactions is not logged.
Considering drop table is like any other transaction, the user is informed
that the table is dropped, and the system crashed, it didn't actually
perform the action of dropping table nor was it logged in WAL, then how it
would cause inconsistency.
Isn't it similar to losing any other last transaction, if not logged.
Thank you.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, nilsocket@gmail.com
Subject: Re: Ambiguos statement in wal-async-commit page
In-Reply-To: <158681229064.25695.12299508971635249207@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox