Re: [GENERAL] ENABLE ROW LEVEL SECURITY cause huge produce of checkpoints

2016-11-09 Thread david . turon
ail servis: ser...@linuxbox.cz - Od: Michael Paquier Komu: david.tu...@linuxbox.cz Kopie: PostgreSQL mailing lists Datum: 09.11.2016 07:10 Předmět: Re: [GENERAL] ENABLE ROW LEVEL SECURITY cause huge produce of checkpoints On Wed, Nov 2, 2016 at 12:

Re: [GENERAL] ENABLE ROW LEVEL SECURITY cause huge produce of checkpoints

2016-11-09 Thread Tom Lane
Michael Paquier writes: > On Wed, Nov 2, 2016 at 12:09 AM, wrote: >> 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 shi

Re: [GENERAL] ENABLE ROW LEVEL SECURITY cause huge produce of checkpoints

2016-11-08 Thread Michael Paquier
On Wed, Nov 2, 2016 at 12:09 AM, wrote: > 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 delay

[GENERAL] ENABLE ROW LEVEL SECURITY cause huge produce of checkpoints

2016-11-01 Thread david . turon
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 s