Re: to drop a 30GB database. is it slow? - Mailing list pgsql-general

From Alban Hertroys
Subject Re: to drop a 30GB database. is it slow?
Date
Msg-id 433CFD77.1020800@magproductions.nl
Whole thread Raw
In response to to drop a 30GB database. is it slow?  (Gábor Farkas <gabor@nekomancer.net>)
Responses Re: to drop a 30GB database. is it slow?
List 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
further.

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

--
Alban Hertroys
alban@magproductions.nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
    7500 AK Enschede

//Showing your Vision to the World//


pgsql-general by date:

Previous
From: Gábor Farkas
Date:
Subject: to drop a 30GB database. is it slow?
Next
From: Zlatko Matić
Date:
Subject: installing several PostgreSQL instances on Windows