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@xxxxxxxxxx>写道：
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
