On 9/3/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > Florian G. Pflug wrote: > > Since we didn't really reach an agreement on how xid_age should behave, > > I've reverted it back to the original version. So with this patch, > > xid_age will just force assignment of a xid. > > Is this really a good idea? I'm repeating myself, but a query like > > select age(xmin) from bigtable > > could accelerate Xid wraparound. If the server is running close to the > limit it could cause a shutdown to prevent the actual wraparound.
Such query would take only one xid, which should not be a problem? -- marko ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly