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

Re: Monitoring Transaction Log size

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: "Ziegelwanger, Silvio" <Silvio(dot)Ziegelwanger(at)fabasoft(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Monitoring Transaction Log size
Date: 2007-01-17 17:57:10
Message-ID: 45AE6376.7060606@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-performance
Ziegelwanger, Silvio wrote:
> Hi,
> 
>  
> 
> how can I monitor the size of the transaction log files using SQL Statements?

You can't. You would have to write a custom function to heck the size of
the xlog directory.

Sincerely,

Joshua D. Drake

> 
>  
> 
> Best Regards
> 
>  
> 
> Silvio
> 
>  
> 
> Silvio Ziegelwanger
> Research & Development
> 
> Fabalabs Software GmbH
> Honauerstraße 4
> 4020 Linz
> Austria
> Tel: [43] (732) 60 61 62
> Fax: [43] (732) 60 61 62-609
> E-Mail: silvio(dot)ziegelwanger(at)fabasoft(dot)com
> www.fabasoft.com <http://www.fabasoft.com/> 
> 
>   <http://www.fabasoft.at/fabasofthomepage2006/fabasoftgruppe/veranstaltungen/fabasoftegovdays07.htm> 
> 
> Fabasoft egovday 07
> Trends im E-Government, Innovationen für eine 
> zukunftsorientierte Verwaltung und digitale Geschäftsprozesse.
> 
> 23. Januar 2007, Bern
> 
> 30. Januar 2007, Berlin
> 
> 6. Februar 2007, Bonn
> 
>  
> 
> 


-- 

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


In response to

Responses

pgsql-performance by date

Next:From: Shoaib MirDate: 2007-01-17 18:03:18
Subject: Re: Monitoring Transaction Log size
Previous:From: Chad WagnerDate: 2007-01-17 17:26:50
Subject: Re: PG8.2.1 choosing slow seqscan over idx scan

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