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

From Neil Conway
Subject Re: WAL bypass for CTAS
Date
Msg-id 42A24543.4000902@samurai.com
Whole thread Raw
In response to Re: WAL bypass for CTAS  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: WAL bypass for CTAS
Re: WAL bypass for CTAS
List pgsql-patches
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?

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.

> I would _love_ to see pg_dump loads use this automatically, without
> having to add clauses to pg_dump output.

What's wrong with adding clauses to the pg_dump output?

-Neil


pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] PGPASSWORD and client tools
Next
From: Bruce Momjian
Date:
Subject: Re: WAL bypass for CTAS