On Thu, Mar 17, 2016 at 2:15 PM, Kevin Grittner <kgri...@gmail.com> wrote: > New patch just to merge in recent commits -- it was starting to > show some bit-rot. Tests folded in with main patch.
I'm not sure if this is operating as expected. I set the value to 1min. I set up a test like this: pgbench -i pgbench -c4 -j4 -T 3600 & ### watch the size of branches table while (true) ; do psql -c "\dt+" | fgrep _branches; sleep 10; done & ### set up a long lived snapshot. psql -c 'begin; set transaction isolation level repeatable read; select sum(bbalance) from pgbench_branches; select pg_sleep(300); select sum(bbalance) from pgbench_branches;' As this runs, I can see the size of the pgbench_branches bloating once the snapshot is taken, and continues bloating at a linear rate for the full 300 seconds. Once the 300 second pg_sleep is up, the long-lived snapshot holder receives an error once it tries to access the table again, and then the bloat stops increasing. But shouldn't the bloat have stopped increasing as soon as the snapshot became doomed, which would be after a minute or so? Cheers, Jeff -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers