Re: too many clog files - Mailing list pgsql-performance

From Greg Smith
Subject Re: too many clog files
Date
Msg-id Pine.GSO.4.64.0809021326150.13072@westnet.com
Whole thread Raw
In response to Re: too many clog files  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: too many clog files
Next
From: Jessica Richard
Date:
Subject: logging options...