pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Greg Williamson <gwilliamson39@yahoo.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Database size stays constant but disk space keeps shrinking -- postgres 9.1
Date: Wed, 17 Oct 2012 14:56:17 -0700 (PDT)
Message-ID: <1350510977.4726.YahooMailNeo@web125906.mail.ne1.yahoo.com> (raw)
In-Reply-To: <CAJKUy5gVL3Ed5GAO3EH313NJYmS9594nFGU-qTbzXYeGkUnN7w@mail.gmail.com>
References: <1348783559.78739.YahooMailNeo@web125906.mail.ne1.yahoo.com>
	<5064D7BC.1000709@pinpointresearch.com>
	<1348797684.2846.YahooMailNeo@web125904.mail.ne1.yahoo.com>
	<10417.1348798479@sss.pgh.pa.us>
	<1348799034.68119.YahooMailNeo@web125902.mail.ne1.yahoo.com>
	<1349215343.78143.YahooMailNeo@web125901.mail.ne1.yahoo.com>
	<e7aa07eea185c183fa4de08d71547a58@2ndquadrant.it>
	<1349301231.12551.YahooMailNeo@web125905.mail.ne1.yahoo.com>
	<CAJKUy5gVL3Ed5GAO3EH313NJYmS9594nFGU-qTbzXYeGkUnN7w@mail.gmail.com>

fantastic !
thanks.
greg





>________________________________
> From: Jaime Casanova <jaime@2ndquadrant.com>
>To: Greg Williamson <gwilliamson39@yahoo.com> 
>Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org> 
>Sent: Wednesday, October 17, 2012 10:05 AM
>Subject: Re: [ADMIN] Database size stays constant but disk space keeps shrinking -- postgres 9.1
> 
>On Wed, Oct 3, 2012 at 4:53 PM, Greg Williamson <gwilliamson39@yahoo.com> wrote:
>>
>> Indeed -- stopping repmgr has lef to a continued accumulation of the dead but not gone file handles, but almost all are now owned by the application, with only a few held by WAL shipping and the like. So repmgr was just getting the blame, unfairly.
>>
>> Am working on the code itself now.
>>
>
>Just in case, it seems like
>http://archives.postgresql.org/pgsql-committers/2012-10/msg00194.php
>is a fix to your problem. It was commited a few minutes ago by Tom
>Lane so you can patch your instalation or wait until the next
>postgresql minor version to be released
>
>-- 
>Jaime Casanova         www.2ndQuadrant.com
>Professional PostgreSQL: Soporte 24x7 y capacitación
>Phone: +593 4 5107566         Cell: +593 987171157
>
>
>

view thread (21+ messages)

Message-ID: <1350510977.4726.YahooMailNeo@web125906.mail.ne1.yahoo.com>
Permalink:  ../1350510977.4726.YahooMailNeo@web125906.mail.ne1.yahoo.com/
Also on:    postgresql.org/message-id/1350510977.4726.YahooMailNeo@web125906.mail.ne1.yahoo.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: gwilliamson39@yahoo.com
  Subject: Re: Database size stays constant but disk space keeps shrinking -- postgres 9.1
  In-Reply-To: <1350510977.4726.YahooMailNeo@web125906.mail.ne1.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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