Home > mailing lists

Re: [GENERAL] FULL_PAGE_WRITES - Mailing list pgsql-general

From	Jov
Subject	Re: [GENERAL] FULL_PAGE_WRITES
Date	June 13, 2017 13:33:52
Msg-id	CADyrUxMnb3R2=1mp8uF1D=Q-rYinOaKg6L2wEs_6ihG_jEn2mQ@mail.gmail.com Whole thread Raw
In response to	[GENERAL] FULL_PAGE_WRITES ("Potukanuma, Vishnu" <vishnusp@amazon.com>)
List	pgsql-general

Tree view

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

pgsql-general by date:

From: Eric Lemoine
Date: 13 June 2017, 11:21:47
Subject: Re: [GENERAL] Performance issue with Pointcloud extension

From: Sari Thiele
Date: 13 June 2017, 14:32:28
Subject: [GENERAL] Missing folder rhel-6Workstation-x86_64 for 9.6 repo (redhat)

Re: [GENERAL] FULL_PAGE_WRITES - Mailing list pgsql-general

Previous

Next