Sv: drop database

From: Andreas Joseph Krogh <andreas(at)visena(dot)com>
To: Julie Nishimura <juliezain(at)hotmail(dot)com>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Sv: drop database
Date: 2019-10-17 20:58:51
Message-ID: VisenaEmail.82.97e945011b03eb60.16ddb83a7a3@tc7-visena
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


På torsdag 17. oktober 2019 kl. 22:44:15, skrev Julie Nishimura <
juliezain(at)hotmail(dot)com <mailto:juliezain(at)hotmail(dot)com>>:
Guys, can anybody reply if they drop any postgresql database larger than 1 tb
and how long did it take?

Thanks

About 280ms:

andreak(at)[local]:5432 12.0 andreak=# select
pg_size_pretty(pg_database_size('rsm'));
┌────────────────┐
│ pg_size_pretty │
├────────────────┤
│ 26 GB │
└────────────────┘
(1 row)

andreak(at)[local]:5432 12.0 andreak=# \timing
Timing is on.
andreak(at)[local]:5432 12.0 andreak=# drop DATABASE rsm;
DROP DATABASE
Time: 280,355 ms

--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andreas(at)visena(dot)com <mailto:andreas(at)visena(dot)com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2019-10-17 20:59:22 Re: drop database
Previous Message Julie Nishimura 2019-10-17 20:44:15 drop database