On 1 June 2012 12:34, Sergey Koposov <kopo...@ast.cam.ac.uk> wrote: > On Fri, 1 Jun 2012, Simon Riggs wrote: > >> >> Why do you have 10,000 tables and why is it important to drop them so >> quickly? > > > 10000 tables are there, because that's the number of partitions. And I'm > dropping them at the moment, because I'm doing testing. So it won't be > really crucial for production. But I still thought it was worth reporting. > Especially when the table dropping took .5 a sec.
Ah, partitions. That explains the long drop time. Hopefully people don't need to do that too frequently. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers