Thread: [GENERAL] FULL_PAGE_WRITES
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
what's the table and index look like? how do you test? Is it HOT update?
For update table and index ,you can read this: http://www.dbrnd.com/2016/12/postgresql-increase-the-speed-of-update-query-using-hot-update-heap-only-tuple-mvcc-fill-factor-vacuum-fragmentation/
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