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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance
