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

From Duan Ligong
Subject Re: too many clog files
Date
Msg-id 20080902091602.CA09.DUANLG@nec-as.nec.com.cn
Whole thread Raw
In response to Re: too many clog files  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: too many clog files  (Greg Smith <gsmith@gregsmith.com>)
List 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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance




pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: slow update of index during insert/copy
Next
From: Russell Smith
Date:
Subject: Re: limit clause breaks query planner?