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" <vishn...@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 >
