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

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

From: Alban Hertroys <alban(at)magproductions(dot)nl>
To: Gábor Farkas <gabor(at)nekomancer(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: to drop a 30GB database. is it slow?
Date: 2005-09-30 08:55:19
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
Gábor Farkas wrote:
> i'm only afraid that maybe if we issue the drop-db command, it will take 
> for example 30minutes...

Wouldn't it be more effective to create a new table by selecting your 
session table and switch their names? You can drop the troublesome table 
afterwards, without influencing the availability of your database any 

This should minimize your downtime, I think - unless people have even 
speedier solutions, of course.

Alban Hertroys

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
A: Postbus 416
    7500 AK Enschede

//Showing your Vision to the World//

In response to


pgsql-general by date

Next:From: Zlatko MatićDate: 2005-09-30 10:22:06
Subject: installing several PostgreSQL instances on Windows
Previous:From: Gábor FarkasDate: 2005-09-30 07:34:31
Subject: to drop a 30GB database. is it slow?

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