Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group