På torsdag 17. oktober 2019 kl. 22:44:15, skrev Julie Nishimura < juliez...@hotmail.com <mailto:juliez...@hotmail.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@[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 -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 andr...@visena.com <mailto:andr...@visena.com> www.visena.com <https://www.visena.com> <https://www.visena.com>