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
[EMAIL PROTECTED]

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//


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org

Reply via email to