Re: to drop a 30GB database. is it slow?

From: Douglas McNaught <doug(at)mcnaught(dot)org>
To: Gábor Farkas <gabor(at)nekomancer(dot)net>
Cc: Alban Hertroys <alban(at)magproductions(dot)nl>, pgsql-general(at)postgresql(dot)org
Subject: Re: to drop a 30GB database. is it slow?
Date: 2005-09-30 12:21:25
Message-ID: m27jcyzqyi.fsf@Douglas-McNaughts-Powerbook.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Gábor Farkas <gabor(at)nekomancer(dot)net> writes:

> so, what if simply dropping the table does not recover the disk-space?

It will. Each table is stored in its own set of disk files, and when
the table is dropped those files are simply deleted.

-Doug

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message James Cradock 2005-09-30 12:44:19 Re: to drop a 30GB database. is it slow?
Previous Message Magnus Hagander 2005-09-30 10:58:55 Re: installing several PostgreSQL instances on Windows