From: Greg Smith <gsmith@gregsmith.com>
To: Guillaume Lelarge <guillaume@lelarge.info>
Cc: Duan Ligong <duanlg@nec-as.nec.com.cn>
Cc: Alvaro Herrera <alvherre@commandprompt.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: too many clog files
Date: Tue, 2 Sep 2008 13:28:45 -0400 (EDT)
Message-ID: <Pine.GSO.4.64.0809021326150.13072@westnet.com> (raw)
In-Reply-To: <48BD7299.6010605@lelarge.info>
References: <20080901191255.E398.DUANLG@nec-as.nec.com.cn>
<20080901143359.GC3776@alvh.no-ip.org>
<20080902091602.CA09.DUANLG@nec-as.nec.com.cn>
<Pine.GSO.4.64.0809020117030.6014@westnet.com>
<48BD7299.6010605@lelarge.info>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: gsmith@gregsmith.com, guillaume@lelarge.info, duanlg@nec-as.nec.com.cn, alvherre@commandprompt.com
Subject: Re: too many clog files
In-Reply-To: <Pine.GSO.4.64.0809021326150.13072@westnet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox