Re: pgsql: In documentaiton, clarify which commands have reduced WAL volume
От | Bruce Momjian |
---|---|
Тема | Re: pgsql: In documentaiton, clarify which commands have reduced WAL volume |
Дата | |
Msg-id | 201108041903.p74J3UY23877@momjian.us обсуждение исходный текст |
Ответ на | Re: pgsql: In documentaiton, clarify which commands have reduced WAL volume (Alvaro Herrera <alvherre@commandprompt.com>) |
Список | pgsql-committers |
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
В списке pgsql-committers по дате отправления: