Reduce WAL logging of INSERT SELECT

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Reduce WAL logging of INSERT SELECT
Дата
Msg-id 201108041950.p74Joa329315@momjian.us
обсуждение исходный текст
Ответы Re: Reduce WAL logging of INSERT SELECT  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
We currently have reduced WAL logging for wal_level = minimum for these
commands:
CREATE TABLE ASCREATE INDEXCLUSTERCOPY into tables that were created or truncated in the sametransaction

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?

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


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

Предыдущее
От: "Petro Meier"
Дата:
Сообщение: PQescapeByteaConn - returns wrong string for PG9.1 Beta3
Следующее
От: daveg
Дата:
Сообщение: Re: error: could not find pg_class tuple for index 2662