fantastic !
thanks.
greg
>
> From: Jaime Casanova
>To: Greg Williamson
>Cc: "pgsql-admin@postgresql.org"
>Sent: Wednesday, October 17, 2012 10:05 AM
>Subject: Re: [ADMIN] Database size stays constant but disk space keeps
>s
On Wed, Oct 3, 2012 at 4:53 PM, Greg Williamson 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
Gabriele --
- Original Message -
> From: Gabriele Bartolini
> To: Greg Williamson
> Cc: pgsql-admin@postgresql.org
> Sent: Wednesday, October 3, 2012 4:41 AM
> Subject: Re: [ADMIN] Database size stays constant but disk space keeps
> shrinking -- postgres 9.1
>
&
On Wed, Oct 3, 2012 at 6:41 AM, Gabriele Bartolini
wrote:
> Hi Greg,
>
>
> On Tue, 2 Oct 2012 15:02:23 -0700 (PDT), Greg Williamson
> wrote:
>
>> Other than abandoning repmgr I don't see a solution. I've posted this
>> to the repmgr discussion group but have had zero responses (and,
>> frankly, a
Hi Greg,
On Tue, 2 Oct 2012 15:02:23 -0700 (PDT), Greg Williamson
wrote:
Other than abandoning repmgr I don't see a solution. I've posted this
to the repmgr discussion group but have had zero responses (and,
frankly, am not holding my breath).
If you are 100% sure it is repmgr ... :)
I am
e: [ADMIN] Database size stays constant but disk space keeps
> shrinking -- postgres 9.1
>
>T om --
>
> - Original Message -
>> From: Tom Lane
>> To: Greg Williamson
>> Cc: "pgsql-admin@postgresql.org"
>
>> Sent: Thursday, September 27,
Dinesh --
- Original Message -
> From: Dinesh Bhandary
> To: Greg Williamson
> Cc: "pgsql-admin@postgresql.org"
> Sent: Thursday, September 27, 2012 7:19 PM
> Subject: Re: [ADMIN] Database size stays constant but disk space keeps
> shrinking -- postgr
wrote:
>Steve (and others who replied):
>
>
>- Original Message -
>>From: Steve Crawford
>>To: Greg Williamson
>>Cc: "pgsql-admin@postgresql.org"
>>Sent: Thursday, September 27, 2012 3:48 PM
>>Subject: Re: [ADMIN] Database size stays constant
Greg Williamson writes:
>> I'll leave it to you and Tom to puzzle over the the postgres-related open
>> files. Meanwhile, I'm a bit curious about the other 800+ and whether they
>> are associated with scripts or processes that are connected to PostgreSQL.
> These all seem to be from two places
Steve --
- Original Message -
> From: Steve Crawford
> To: Greg Williamson
> Cc: "pgsql-admin@postgresql.org"
> Sent: Friday, September 28, 2012 8:59 AM
> Subject: Re: [ADMIN] Database size stays constant but disk space keeps
> shrinking -- postgres 9.1
We had a situation where external sort was creating a humungous temp
file and the space was reclaimed when the process was completed.
Thanks.
Dinesh
On 9/28/2012 8:59 AM, Steve Crawford wrote:
On 09/27/2012 07:01 PM, Greg Williamson wrote:
Steve (and others who replied):
...
The other is a
On 09/27/2012 07:01 PM, Greg Williamson wrote:
Steve (and others who replied):
...
The other is a slimmed-down version of our production database, which gets
recreated hourly by a shell script which pulls data from remote servers, does a
pg_dump of the resulting 3 gig database, and then drops
Tom --
- Original Message -
> From: Tom Lane
> To: Greg Williamson
> Cc: "pgsql-admin@postgresql.org"
> Sent: Thursday, September 27, 2012 7:55 PM
> Subject: Re: [ADMIN] Database size stays constant but disk space keeps
> shrinking -- postgres 9.1
Greg Williamson writes:
>>> postgres 2540 postgres 50u REG8,3 409600
>>> 93429 /var/lib/postgresql/9.1/main/base/2789200/11816 (deleted)
>>> postgres 2540 postgres 51u REG8,3 18112512
>>> 49694570 /var/lib/postgresql/9.1/main/base/278
Tom --
- Original Message -
> From: Tom Lane
> To: Greg Williamson
> Cc: "pgsql-admin@postgresql.org"
> Sent: Thursday, September 27, 2012 7:14 PM
> Subject: Re: [ADMIN] Database size stays constant but disk space keeps
> shrinking -- postgres 9.1
Greg Williamson writes:
>> Have you checked to see if there are any processes that have open handles to
>> deleted files (lsof -X | grep deleted).
> lsof -X | grep deleted | wc -l
> shows: 835 such files.
> A couple:
> postgres 2540 postgres 50u REG8,3 409600
Steve (and others who replied):
- Original Message -
> From: Steve Crawford
> To: Greg Williamson
> Cc: "pgsql-admin@postgresql.org"
> Sent: Thursday, September 27, 2012 3:48 PM
> Subject: Re: [ADMIN] Database size stays constant but disk space keeps
&g
You might also want to check to see if temp files are growing out of bounds.
Thanks.
Dinesh
On 9/27/2012 3:05 PM, Greg Williamson wrote:
Dear list,
I have a postgres database, 9.1.3, which shows a fairly constant amount of
space used by postgres, but total disk space kees shrinking.
If I resta
Hi Greg,
On Fri, Sep 28, 2012 at 8:05 AM, Greg Williamson wrote:
>
> I have a postgres database, 9.1.3, which shows a fairly constant amount of
> space used by postgres, but total disk space kees shrinking.
> If I restart postgres the space on my file system returns.
>
It sounds like (maybe?) Po
On 09/27/2012 03:05 PM, Greg Williamson wrote:
Dear list,
I have a postgres database, 9.1.3, which shows a fairly constant amount of
space used by postgres, but total disk space kees shrinking.
If I restart postgres the space on my file system returns.
This cluster is replicated to another; th
Dear list,
I have a postgres database, 9.1.3, which shows a fairly constant amount of
space used by postgres, but total disk space kees shrinking.
If I restart postgres the space on my file system returns.
This cluster is replicated to another; that custer does not show this problem.
There are
21 matches
Mail list logo
