Re: Reduce WAL logging of INSERT SELECT

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Reduce WAL logging of INSERT SELECT
Date: 2011-08-04 20:55:35
Message-ID: 15010.1312491335@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruce Momjian <bruce(at)momjian(dot)us> writes:
> One thing we don't optimize is INSERT ... SELECT when the table is
> created or truncated in the same transaction. Seems we could.

> We optimize CREATE TABLE AS which is effectively SELECT ... INTO using a
> different syntax. Is this a TODO?

Considering that SELECT INTO is deprecated, I don't think we should be
expending effort to encourage people to use it.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2011-08-04 21:03:23 Re: Reduce WAL logging of INSERT SELECT
Previous Message Tom Lane 2011-08-04 20:54:14 Re: PQescapeByteaConn - returns wrong string for PG9.1 Beta3