Re: too many clog files

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Greg Smith <gsmith(at)gregsmith(dot)com>
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:06:33
Message-ID: 48BD7299.6010605@lelarge.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Smith 2008-09-02 17:28:45 Re: too many clog files
Previous Message David West 2008-09-02 14:09:00 Re: limit clause breaks query planner?