pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedclog files
2+ messages / 2 participants
[nested] [flat]
* clog files
@ 2009-03-23 15:44 fatih ozturk <ozturkfa@yahoo.com>
2009-03-24 14:13 ` Re: clog files Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 2+ messages in thread
From: fatih ozturk @ 2009-03-23 15:44 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: clog files
2009-03-23 15:44 clog files fatih ozturk <ozturkfa@yahoo.com>
@ 2009-03-24 14:13 ` Bruce Momjian <bruce@momjian.us>
0 siblings, 0 replies; 2+ messages in thread
From: Bruce Momjian @ 2009-03-24 14:13 UTC (permalink / raw)
To: fatih ozturk <ozturkfa@yahoo.com>; +Cc: pgsql-admin
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. +
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2009-03-24 14:13 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-03-23 15:44 clog files fatih ozturk <ozturkfa@yahoo.com>
2009-03-24 14:13 ` Bruce Momjian <bruce@momjian.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox