Обсуждение: pgsql: In documentaiton, clarify which commands have reduced WAL volume
In documentaiton, clarify which commands have reduced WAL volume for wal_level = minimum. Backpatch to 9.1 and 9.0. Branch ------ master Details ------- http://git.postgresql.org/pg/commitdiff/38de5aad54b3eb37981cacd391fcde82f86d00fb Modified Files -------------- doc/src/sgml/config.sgml | 17 ++++++++++++----- 1 files changed, 12 insertions(+), 5 deletions(-)
Excerpts from Bruce Momjian's message of jue ago 04 12:07:15 -0400 2011: > In documentaiton, clarify which commands have reduced WAL volume for > wal_level = minimum. Sorry that I misled you -- my tags were just an example, I wasn't trying to imply that the markup was correct. (A quick make check would have told you as much). -- Álvaro Herrera <alvherre@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Alvaro Herrera wrote: > Excerpts from Bruce Momjian's message of jue ago 04 12:07:15 -0400 2011: > > In documentaiton, clarify which commands have reduced WAL volume for > > wal_level = minimum. > > Sorry that I misled you -- my tags were just an example, I wasn't trying > to imply that the markup was correct. (A quick make check would have > told you as much). I see. :-( Fixed with the attached patch and backpatched. I added the <command> tag as well. It does seems <simplelist> is best here. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml new file mode 100644 index b774e2a..33db25f *** a/doc/src/sgml/config.sgml --- b/doc/src/sgml/config.sgml *************** SET ENABLE_SEQSCAN TO OFF; *** 1456,1466 **** operations much faster (see <xref linkend="populate-pitr">). Operations in which this optimization can be applied include: <simplelist> ! <item>CREATE TABLE AS</item> ! <item>CREATE INDEX</item> ! <item>CLUSTER</item> ! <item>COPY into tables that were created or truncated in the same ! transaction </simplelist> But minimal WAL does not contain enough information to reconstruct the data from a base backup and the --- 1456,1466 ---- operations much faster (see <xref linkend="populate-pitr">). Operations in which this optimization can be applied include: <simplelist> ! <member><command>CREATE TABLE AS</></member> ! <member><command>CREATE INDEX</></member> ! <member><command>CLUSTER</></member> ! <member><command>COPY</> into tables that were created or truncated in the same ! transaction</member> </simplelist> But minimal WAL does not contain enough information to reconstruct the data from a base backup and the