AW: Vacuum only with 20% old tuples - Mailing list pgsql-hackers

From Zeugswetter Andreas SB
Subject AW: Vacuum only with 20% old tuples
Date
Msg-id 11C1E6749A55D411A9670001FA687963368028@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
List pgsql-hackers
> OK,I see. Your idea seems to be close to Vadim's *relink*. 
> However it isn't clear if *relink* has no problem.
> In my test case on cygwin port ,*relink* doesn't work well.
> *relink* caused an error if concurrent backends open the
> *relink*ing table.

All actions involving a rename of a file imho involve exclusive access 
to the table, thus no concurrent access is allowed/possible.

Andreas


pgsql-hackers by date:

Previous
From: "Hiroshi Inoue"
Date:
Subject: RE: Vacuum only with 20% old tuples
Next
From: Hiroshi Inoue
Date:
Subject: Re: AW: Vacuum only with 20% old tuples