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 |
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 |