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
>
> On 09/27/2012 07:01 PM, Gre
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
