Thread: clog files
| 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 |
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@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +