Re: WAL bypass for CTAS - Mailing list pgsql-patches

From Simon Riggs
Subject Re: WAL bypass for CTAS
Date
Msg-id 1117958797.3844.1257.camel@localhost.localdomain
Whole thread Raw
In response to Re: WAL bypass for CTAS  (Neil Conway <neilc@samurai.com>)
List pgsql-patches
On Sun, 2005-06-05 at 10:20 +1000, Neil Conway wrote:
> Bruce Momjian wrote:
> > Could we do your NOLOGGING automatically in COPY if we test to see if
> > anyone else is connected to our current database?

Remember that this patch doe NOT yet handle COPY, but that is planned...

> That seems pretty fragile -- what happens if someone connects after the
> COPY has started? Considering that many COPY operations can take many
> minutes or hours, I don't think it is wise to make assumptions based on
> the initial state of the system.

Agreed.

Best Regards, Simon Riggs


pgsql-patches by date:

Previous
From: Dennis Bjorklund
Date:
Subject: Re: lastval()
Next
From: Andreas Pflug
Date:
Subject: Re: Server instrumentation: pg_terminate_backend, pg_reload_conf