Re: Sv: drop database

Ron <ronljohnsonjr@xxxxxxxxx> · Thu, 17 Oct 2019 16:01:08 -0500



    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.