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

From Guillaume Lelarge
Subject Re: too many clog files
Date
Msg-id 48BD7299.6010605@lelarge.info
Whole thread Raw
In response to Re: too many clog files  (Greg Smith <gsmith@gregsmith.com>)
Responses Re: too many clog files  (Greg Smith <gsmith@gregsmith.com>)
List pgsql-performance
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.org
 http://dalibo.com

pgsql-performance by date:

Previous
From: "David West"
Date:
Subject: Re: limit clause breaks query planner?
Next
From: Greg Smith
Date:
Subject: Re: too many clog files