"Christian Plattner" <[EMAIL PROTECTED]> writes:
> From: "Tom Lane" <[EMAIL PROTECTED]>
>> How much later?  clog is not kept forever.

> As far as I understand your code there is only one chance that information
> in clog gets lost:
> If XIDs are reused then ExtendCLOG will overwrite existing entries.
> Also, it seems to me that VACCUM has not effect on the clog.

You're quite mistaken.  clog is truncated during vacuum, once we are
confident that there are no unvacuumed rows in the database with XIDs
older than a certain point.  This is to keep clog space requirements
within reason.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?


Reply via email to