clog files

--0-639249989-1237823072=:7554
Content-Type: text/plain; charset=us-ascii

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




--0-639249989-1237823072=:7554
Content-Type: text/html; charset=us-ascii

Re: clog files

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