Re: too many clog files

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