Re: WAL logging volume and CREATE TABLE

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: WAL logging volume and CREATE TABLE
Дата
Msg-id 201108041607.p74G70i13662@momjian.us
обсуждение исходный текст
Ответ на Re: WAL logging volume and CREATE TABLE  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
Patch applied.

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

Bruce Momjian wrote:
> 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: 
> > <simplelist>
> >  <item>CREATE INDEX</item>
> >  <item>CLUSTER</item>
> >  <item>CREATE TABLE AS</item>
> >  <item>COPY, when tables that were created or truncated in the same
> >  transaction
> > </simplelist>
> > 
> > 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@momjian.us>        http://momjian.us
>   EnterpriseDB                             http://enterprisedb.com
> 
>   + It's impossible for everything to be true. +


> 
> -- 
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: lazy vxid locks, v3
Следующее
От: Robert Haas
Дата:
Сообщение: Re: psql: display of object comments