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: 433CFD77.1020800@magproductions.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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
further.

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

--
Alban Hertroys
alban(at)magproductions(dot)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//

In response to

Responses

Browse pgsql-general by date

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