"Gregory Stark" <[EMAIL PROTECTED]> writes: > "Joshua D. Drake" <[EMAIL PROTECTED]> writes: > >> On Mon, 7 Jan 2008 11:58:29 -0500 (EST) >> Bruce Momjian <[EMAIL PROTECTED]> wrote: >> >>> I assume it is this TODO item: >>> >>> o Prevent long-lived temporary tables from causing frozen-xid >>> advancement starvation >>> >>> The problem is that autovacuum cannot vacuum them to set >>> frozen xids; only the session that created them can do that. >>> http://archives.postgresql.org/pgsql-general/2007-06/msg01645.php >>> >>> but am confused how the fix worked. Have all of these backends been >>> active for 1 billion transactions? >> >> Well it certainly appears that the TODO item is related. However there >> are a couple of differences. > > Yeah, it seems there are two bugs here. 1) temporary tables prevent frozen-xid > advancement and 2) if a process dies at the wrong moment it's possible to > temporary tables. Either one alone is pretty minor but I guess the combination > is lethal.
oops, "2) if a process dies at the wrong moment it's possible to *leak* temporary tables" -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production Tuning ---------------------------(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
