From: Guillaume Lelarge <guillaume@lelarge.info>
To: Greg Smith <gsmith@gregsmith.com>
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, 02 Sep 2008 19:06:33 +0200
Message-ID: <48BD7299.6010605@lelarge.info> (raw)
In-Reply-To: <Pine.GSO.4.64.0809020117030.6014@westnet.com>
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>
Greg Smith a écrit :
> [...]
>> - When, or in what case is a new clog file produced?
>
> Every 32K transactions.
Are you sure about this?
y clog files get up to 262144 bytes. Which means 1000000 transactions'
status: 262144 bytes are 2Mb (mega bits), so if a status is 2 bits, it
holds 1M transactions' status).
AFAICT, 32K transactions' status are available on a single (8KB) page.
Or am I wrong?
--
Guillaume.
http://www.postgresqlfr.orghttp://dalibo.com
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: guillaume@lelarge.info, gsmith@gregsmith.com, duanlg@nec-as.nec.com.cn, alvherre@commandprompt.com
Subject: Re: too many clog files
In-Reply-To: <48BD7299.6010605@lelarge.info>
* 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