Re: too many clog files

From: Duan Ligong <duanlg(at)nec-as(dot)nec(dot)com(dot)cn>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: too many clog files
Date: 2008-09-02 01:38:21
Message-ID: 20080902091602.CA09.DUANLG@nec-as.nec.com.cn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Alvaro Herrera wrote:
> > Duan Ligong wrote:
> > I have encountered an issue that there are too many
> > clog file under the .../pg_clog/ directory. Some of them
> > were even produced one month ago.
>
> If you're going to repost a question, it is only polite that you link to
> the answers already provided. Particularly so when some of your
> questions were already answered.

OK, the following was the answer from you.
http://archives.postgresql.org/pgsql-performance/2008-08/msg00346.php
I appreciate your reply, but please
don't be such instructive except on postgresql.

In fact , I didn't get a satisfactory answer from you because
"Sorry, you ask more questions that I have time to answer right now."

So I tried to make my questions less and simpler as follows:
- Does Vacuum delete the old clog files?
- Can we controll the maximum number of the clog files?
- When, or in what case is a new clog file produced?
- Is there a mechanism that the clog files are recycled? If there is ,
what is the mechanism?

#The version of my postgresql is 8.1.
I have encountered an issue that there are too many
clog file under the .../pg_clog/ directory. Some of them
were even produced one month ago.

Thanks
Duan

>
> --
> Alvaro Herrera http://www.CommandPrompt.com/
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Russell Smith 2008-09-02 03:54:53 Re: limit clause breaks query planner?
Previous Message Greg Smith 2008-09-02 00:46:22 Re: slow update of index during insert/copy