Jeffrey Baker <jwbaker(at)acm(dot)org> writes:
> 04 begin
> 05 work
> 06 commit
> 07 begin connect
> 08 work begin
> 09 commit delete everything
> 10 begin commit
> 11 work vacuum <= this should get rid of everything < t = 07
> 12 commit disconnect
Actually that vacuum should get rid of everything older than t=10.
What I'm concerned about is this scenario:
client A client B you
begin;
work...
commit;
begin;
take a lunch break...
begin;
work...
commit;
connect
vacuum;
Until client A returns from his lunch break, you'll not be able to
vacuum the trash that client B generated, even though B has committed
his changes.
regards, tom lane