Re: [GENERAL] FULL_PAGE_WRITES

Поиск
Список
Период
Сортировка
От Jov
Тема Re: [GENERAL] FULL_PAGE_WRITES
Дата
Msg-id CADyrUxMnb3R2=1mp8uF1D=Q-rYinOaKg6L2wEs_6ihG_jEn2mQ@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] FULL_PAGE_WRITES  ("Potukanuma, Vishnu" <vishnusp@amazon.com>)
Список pgsql-general
Дерево обсуждения
what's the table and index look like? how do you test? Is it HOT update?

2017年6月13日 1:06 PM，"Potukanuma, Vishnu" <vishnusp@amazon.com>写道：

 

Hi,

 

I am new to postgres, I have a simple question.

When this parameter FULL_PAGE_WRITES is set to ON, it writes the FULL pages to WAL, does it write just the data pages or both the index pages as well.

I tried running update statement on the table which updates the same number of rows with and without the index, the WAL size is the same.

 

Thanks,

Vishnu

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

Предыдущее
От: Eric Lemoine
Дата:
Сообщение: Re: [GENERAL] Performance issue with Pointcloud extension
Следующее
От: Sari Thiele
Дата:
Сообщение: [GENERAL] Missing folder rhel-6Workstation-x86_64 for 9.6 repo (redhat)