X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 68CE311F605F for ; Mon, 24 Apr 2006 18:37:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 05085-06 for ; Mon, 24 Apr 2006 18:37:06 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 9D92811F610C for ; Mon, 24 Apr 2006 18:37:04 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k3OLauxs006698; Mon, 24 Apr 2006 17:36:56 -0400 (EDT) To: Alvaro Herrera cc: "Jim C. Nasby" , Gourish Singbal , "pgsql-admin@postgresql.org" Subject: Re: Autovacuuming In-reply-to: <20060424190603.GC16134@surnet.cl> References: <674d1f8a0604232251v4649b456xc542fd831f8db4@mail.gmail.com> <20060424124155.GA13361@surnet.cl> <20060424180038.GG48010@pervasive.com> <20060424190603.GC16134@surnet.cl> Comments: In-reply-to Alvaro Herrera message dated "Mon, 24 Apr 2006 15:06:03 -0400" Date: Mon, 24 Apr 2006 17:36:56 -0400 Message-ID: <6697.1145914616@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/252 X-Sequence-Number: 21421 Alvaro Herrera writes: > Jim C. Nasby wrote: >> Ok, I'll bite... any idea how (MaxTransactionId >> 3) * 3 was chosen? I >> don't see anything about it in vacuum.c... > I don't remember exactly why was that constant chosen. IIRC Tom pulled > it out of thin air. Pretty much. One of the main constraints at the time was that we wanted it to be warning for a good long time before actual wraparound happened, because the consequences would be so catastrophic. Now that there's some failsafe code in place, it might be reasonable to narrow the margin so it doesn't start bleating quite so soon. We'd still be pulling specific numbers out of the air though ... regards, tom lane