Re: Unaccounted for disk use

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Chris Cameron <chris(at)upnix(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Unaccounted for disk use
Date: 2003-05-21 04:27:18
Message-ID: 4742.1053491238@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Chris Cameron <chris(at)upnix(dot)com> writes:
> I was running the pgMigration plugin for PgAdminII and half way along,
> it failed.

> Thing is, there's about 142 megs of space being used up by my data/
> directory that really doesn't show up as tables anywhere.

> The database that was receiving all this information is empty. I've done
> what little I could think of which is turn Postgres off and on again,
> and vaccumm the DB(s). The space is still being used.

Indexes? WAL space? Poke around with "du" ...

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Reshat Sabiq 2003-05-21 07:10:58 Re: ENCODING (Unicode)
Previous Message Paul Fontenot 2003-05-21 03:27:16 Re: Unaccounted for disk use