På torsdag 17. oktober 2019 kl. 22:44:15, skrev Julie Nishimura <juliezain@xxxxxxxxxxx>:
Guys, can anybody reply if they drop any postgresql database larger than 1 tb and how long did it take?Thanks
About 280ms:
andreak@[local]:5432 12.0 andreak=# select pg_size_pretty(pg_database_size('rsm'));
┌────────────────┐
│ pg_size_pretty │
├────────────────┤
│ 26 GB │
└────────────────┘
(1 row)
andreak@[local]:5432 12.0 andreak=# \timing
Timing is on.
andreak@[local]:5432 12.0 andreak=# drop DATABASE rsm;
DROP DATABASE
Time: 280,355 ms
┌────────────────┐
│ pg_size_pretty │
├────────────────┤
│ 26 GB │
└────────────────┘
(1 row)
andreak@[local]:5432 12.0 andreak=# \timing
Timing is on.
andreak@[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
