Re: too many clog files

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: Duan Ligong <duanlg(at)nec-as(dot)nec(dot)com(dot)cn>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: too many clog files
Date: 2008-09-02 17:28:45
Message-ID: Pine.GSO.4.64.0809021326150.13072@westnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jessica Richard 2008-09-02 17:35:54 logging options...
Previous Message Guillaume Lelarge 2008-09-02 17:06:33 Re: too many clog files