Alvaro Herrera wrote:
> Excerpts from Bruce Momjian's message of mar ago 02 22:46:55 -0400 2011:
> > I have created a documentation patch to clarify this, and to mention
> > CREATE TABLE AS which also has this optimization.
> It doesn't seem particularly better to me. How about something like
> In minimal level, WAL-logging of some operations can be safely skipped,
> which can make those operations much faster (see <blah>). Operations on
> which this optimization can be applied include:
> <item>CREATE INDEX</item>
> <item>CREATE TABLE AS</item>
> <item>COPY, when tables that were created or truncated in the same
> Minimal WAL does not contain enough information to reconstruct the data
> from a base backup and the WAL logs, so either <literal>archive</> or
> <literal>hot_standby</> level must be used to enable ...
Good idea --- updated patch attached.
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
+ It's impossible for everything to be true. +
In response to
pgsql-hackers by date
|Next:||From: Robert Haas||Date: 2011-08-03 19:11:44|
|Subject: Re: mosbench revisited|
|Previous:||From: Tom Lane||Date: 2011-08-03 18:49:31|
|Subject: Re: mosbench revisited |