From: | Jov <amutu(at)amutu(dot)com> |
---|---|
To: | "Potukanuma, Vishnu" <vishnusp(at)amazon(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: FULL_PAGE_WRITES |
Date: | 2017-06-13 07:33:52 |
Message-ID: | CADyrUxMnb3R2=1mp8uF1D=Q-rYinOaKg6L2wEs_6ihG_jEn2mQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)amazon(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Sari Thiele | 2017-06-13 08:32:28 | Missing folder rhel-6Workstation-x86_64 for 9.6 repo (redhat) |
Previous Message | Eric Lemoine | 2017-06-13 05:21:47 | Re: Performance issue with Pointcloud extension |