[GENERAL] FULL_PAGE_WRITES - Mailing list pgsql-general

From Potukanuma, Vishnu
Subject [GENERAL] FULL_PAGE_WRITES
Date
Msg-id 5CC63043-AA69-42E4-A44C-5AE48D6256B2@amazon.com
Whole thread Raw
List pgsql-general

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:

Previous
From: Justin Pryzby
Date:
Subject: Re: [GENERAL] workaround for column cross-correlation
Next
From: "Potukanuma, Vishnu"
Date:
Subject: [GENERAL] FULL_PAGE_WRITES