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