Skip site navigation (1) Skip section navigation (2)

Re: clog files

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: fatih ozturk <ozturkfa(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: clog files
Date: 2009-03-24 14:13:47
Message-ID: 200903241413.n2OEDlX23236@momjian.us (view raw or flat)
Thread:
Lists: 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(at)momjian(dot)us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

  • clog files at 2009-03-23 15:44:32 from fatih ozturk

pgsql-admin by date

Next:From: Kasia TuszynskaDate: 2009-03-24 17:43:34
Subject: logging a single user session
Previous:From: Albe LaurenzDate: 2009-03-24 09:31:30
Subject: Re: [GENERAL] Accessing large objects

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group