ENABLE ROW LEVEL SECURITY cause huge produce of checkpoints

From: david(dot)turon(at)linuxbox(dot)cz
To: pgsql-general(at)postgresql(dot)org
Subject: ENABLE ROW LEVEL SECURITY cause huge produce of checkpoints
Date: 2016-11-01 15:09:31
Message-ID: OFF167DCC1.C4FE2E82-ONC125805E.004EE1F8-C125805E.00534522@notes.linuxbox.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

we tried new feature RLS - tested on postgres 9.5.3 / CentOS6. When we turn
on ENABLE RLS + FORCE RLS on normal workload cause huge produce checkpoints
(about 30x or more), our disk partition for xlog was full and log shipping
to replica maybe delayed removing old checkpoints. Have anybody same
experiences after turn on RLS? Looks like more buffers set as dirty. Yes,
we can provide more space for xlog, but it will take much more space for
xlog backups. We do not know if it's worth it. We had log_checkpoints ON
and I send log as attachment (RLS Turn ON at 13:26).

Thanks for any idea or explanation reasons if its normal behavior.

David
(See attached file: checkpoints)

--
-------------------------------------
Ing. David TUROŇ
LinuxBox.cz, s.r.o.
28. rijna 168, 709 01 Ostrava

tel.: +420 591 166 224
fax: +420 596 621 273
mobil: +420 732 589 152
www.linuxbox.cz

mobil servis: +420 737 238 656
email servis: servis(at)linuxbox(dot)cz
-------------------------------------

Attachment Content-Type Size
checkpoints application/octet-stream 95.1 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua Kehn 2016-11-01 19:01:22 Re: Validity of using the test_decoding plugin for production?
Previous Message Melvin Davidson 2016-11-01 14:52:18 Re: Statistics on index usage