[GENERAL] COPY log row count feauture request

Hi everyone, i have question if is possible log count row of COPY command to csv/syslog. I know that there are some limitations like triggers BEFORE INSERT. Don't know if any others were pleased with this feature. Have a nice day. David -- - Ing. David

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

Hello, thanks for reply, I investigated this and thanks to pg_xlog_dump i found: /usr/pgsql-9.5/bin/pg_xlogdump 00010870007C 00010870007D | head -1 rmgr: Heaplen (rec/tot): 7/53, tx: 284003096, lsn: 870/7C30, prev 870/7BD0, desc: LOCK off 2:

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

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

[GENERAL] Strange/Correct? behavior of SELECT FOR UPDATE

Hi, we have some question about behavior SELECT FOR UPDATE. We want find record with open bounds tstzrange, close it a insert new open. We use SELECT FOR UPDATE in function, but sometimes 2rows inserted. I show this on simple example with integer data type. Here is: --tested on postgresql