Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 2E8A6650469 for ; Tue, 2 Sep 2008 15:44:19 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 62869-08-3 for ; Tue, 2 Sep 2008 15:44:10 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from westnet.com (westnet.com [216.187.52.2]) by postgresql.org (Postfix) with ESMTP id CE808650821 for ; Tue, 2 Sep 2008 14:28:53 -0300 (ADT) Received: from westnet.com (localhost [127.0.0.1]) by westnet.com (8.14.0/8.14.0) with ESMTP id m82HSkbg015743; Tue, 2 Sep 2008 13:28:46 -0400 (EDT) Received: from localhost (gsmith@localhost) by westnet.com (8.14.0/8.13.2/Submit) with ESMTP id m82HSjUN015734; Tue, 2 Sep 2008 13:28:45 -0400 (EDT) X-Authentication-Warning: westnet.com: gsmith owned process doing -bs Date: Tue, 2 Sep 2008 13:28:45 -0400 (EDT) From: Greg Smith X-X-Sender: gsmith@westnet.com To: Guillaume Lelarge cc: Duan Ligong , Alvaro Herrera , pgsql-performance@postgresql.org Subject: Re: too many clog files In-Reply-To: <48BD7299.6010605@lelarge.info> Message-ID: References: <20080901191255.E398.DUANLG@nec-as.nec.com.cn> <20080901143359.GC3776@alvh.no-ip.org> <20080902091602.CA09.DUANLG@nec-as.nec.com.cn> <48BD7299.6010605@lelarge.info> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200809/38 X-Sequence-Number: 31351 On Tue, 2 Sep 2008, Guillaume Lelarge wrote: > AFAICT, 32K transactions' status are available on a single (8KB) page. You're right, I had that right on the refered to page but mangled it when writing the e-mail. > 262144 bytes are 2Mb (mega bits), so if a status is 2 bits, [a clog > file] holds 1M transactions' status). Exactly. -- * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD