fatih ozturk wrote: > Hi > I want to ask some part of a question that is asked before by "Duan Ligong" and not answered > > " > Could you explain how the clog files work roughly? > > (What is inside of the clog files? when and how the new clog files > > are created? when and in what case the old files are deleted > > or rotated? how does postgresql regard a file is old enough to be > > deleted? Does Vacuum will definitely cause deleting of old files > > and creating of new clog files?) > " > > Thansk for your interest There is a slide here of the clog file internals: http://momjian.us/main/writings/pgsql/internalpics.pdf clog is rotated on its own by our code and there is no user maintenence required. You have to look in our C code for the rest of the answers. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin