From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Jeff MacDonald <bignose(at)gmail(dot)com> |
Cc: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Diskspace |
Date: | 2004-12-20 19:44:16 |
Message-ID: | 20041220194412.GA18598@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
VACUUM or VACUUM FULL. Only the second actually reclaims diskspace...
On Mon, Dec 20, 2004 at 03:21:51PM -0400, Jeff MacDonald wrote:
> well, i did a "delete from email_log" and then a vacuum and the files
> are still lingering around...
>
> still huge. the postmaster did die due to a diskspace issue, so i
> wonder if it's still just keeping a wierd lock on those files or
> something.. idea's ?
>
>
> On Mon, 20 Dec 2004 11:01:32 -0300, Alvaro Herrera
> <alvherre(at)dcc(dot)uchile(dot)cl> wrote:
> > On Mon, Dec 20, 2004 at 09:57:35AM -0400, Jeff MacDonald wrote:
> >
> > > # select relname,relfilenode,relpages from pg_class where relfilenode
> > > = 13312279;
> > > relname | relfilenode | relpages
> > > -----------+-------------+----------
> > > email_log | 13312279 | 36821
> > >
> > > It just so happens that email_log has around 700,000 rows, that would
> > > explain the space issues.
> > >
> > > I do know that email_log is 100% deleteable, so I'll proceed with hosing that.
> > >
> > > Does all this sound reasonable ?
> >
> > Certainly.
> >
> > --
> > Alvaro Herrera (<alvherre[(at)]dcc(dot)uchile(dot)cl>)
> > "Para tener más hay que desear menos"
> >
>
>
> --
> Jeff MacDonald
> http://www.halifaxbudolife.ca
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-12-20 19:53:40 | Re: Diskspace |
Previous Message | Steve Atkins | 2004-12-20 19:39:52 | Short circuit operations in plpgsql? |