Search Postgresql Archives

Re: Sv: drop database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 10/17/19 3:58 PM, Andreas Joseph Krogh wrote:
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


1TB is 38x larger than 26GB. 


--
Angular momentum makes the world go 'round.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux