Re: Diskspace

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