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: Mon, 1 Oct 2012 14:37:20 -0700 (PDT)
Message-ID: <1349127440.56154.YahooMailNeo@web125904.mail.ne1.yahoo.com> (raw)
In-Reply-To: <18883255.471348798791198.OPEN-XCHANGE.WebMail.tomcat@moxie.iii.com>
References: <1348783559.78739.YahooMailNeo@web125906.mail.ne1.yahoo.com>
<5064D7BC.1000709@pinpointresearch.com>
<1348797684.2846.YahooMailNeo@web125904.mail.ne1.yahoo.com>
<18883255.471348798791198.OPEN-XCHANGE.WebMail.tomcat@moxie.iii.com>
Dinesh --
----- Original Message -----
> From: Dinesh Bhandary <bhandary@iii.com>
> To: Greg Williamson <gwilliamson39@yahoo.com>
> Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
> Sent: Thursday, September 27, 2012 7:19 PM
> Subject: Re: [ADMIN] Database size stays constant but disk space keeps shrinking -- postgres 9.1
>
>
> I'd also keep track of tmp directory while building. I hope it is not
> creating a huge external sort file. By building you meant to say
> pg_restore, I assume.
Actually everything is done a single SQL commands; the DDL from the source gets run on the new database, and then we do a series of SQL commands. The tmp space doesn't seem to get hit as there are only a few sorts being run as we reduce a list of "users from" and "users to" to a single list of unique user ids.
> How big is your maintenance_work_mem? Index creation pools memory from
> this buffer.
maintenance_work_mem = 1500MB# min 1MB
Which seems to be enough for this task set.
postgres@db11:~/9.1/main$ ls -lrt base/pgsql_tmp
total 0
Something malign in one of our applications, perhaps interacting with this hourly drop. Still working with the developers to see what they are doing "under the hood."
Thanks for the suggestions!
Greg
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: <1349127440.56154.YahooMailNeo@web125904.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