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