| From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Sv: drop database |
| Date: | 2019-10-17 21:01:08 |
| Message-ID: | 8ff311cb-48ad-ec66-ca90-4e00dce09d48@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 10/17/19 3:58 PM, Andreas Joseph Krogh wrote:
> 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]:543212.0 andreak=# select
> pg_size_pretty(pg_database_size('rsm'));
> ┌────────────────┐
> │ pg_size_pretty │
> ├────────────────┤
> │ 26 GB │
> └────────────────┘
> (1 row)
>
> andreak(at)[local]:543212.0 andreak=# \timing
> Timing is on.
> andreak(at)[local]:543212.0 andreak=# drop DATABASE rsm;
> DROP DATABASE
> Time: 280,355 ms
1TB is 38x larger than 26GB.
--
Angular momentum makes the world go 'round.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Julie Nishimura | 2019-10-17 21:19:20 | Re: drop database |
| Previous Message | Andreas Joseph Krogh | 2019-10-17 20:59:42 | Sv: drop database |