HEAD seems to generate larger WAL regarding GIN index

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема HEAD seems to generate larger WAL regarding GIN index
Дата
Msg-id CAHGQGwE3xnytNBY0mnLbQ9+QvgPvL44iEE6bcnsm86eanPWEjg@mail.gmail.com
обсуждение исходный текст
Ответы Re: HEAD seems to generate larger WAL regarding GIN index  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Список pgsql-hackers
Hi,

I executed the following statements in HEAD and 9.3, and compared
the size of WAL which were generated by data insertion in GIN index.

---------------------
CREATE EXTENSION pg_trgm;
CREATE TABLE hoge (col1 text);
CREATE INDEX hogeidx ON hoge USING gin (col1 gin_trgm_ops) WITH
(FASTUPDATE = off);

CHECKPOINT;
SELECT pg_switch_xlog();
SELECT pg_switch_xlog();

SELECT pg_current_xlog_location();
INSERT INTO hoge SELECT 'POSTGRESQL' FROM generate_series(1, 1000000);
SELECT pg_current_xlog_location();
---------------------

The results of WAL size are
   960 MB (9.3) 2113 MB (HEAD)

The WAL size in HEAD was more than two times bigger than that in 9.3.
Recently the source code of GIN index has been changed dramatically.
Is the increase in GIN-related WAL intentional or a bug?

Regards,

-- 
Fujii Masao



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

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: Archive recovery won't be completed on some situation.
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: HEAD seems to generate larger WAL regarding GIN index