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
Список 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 по дате отправления: