Re: slow dropping of tables, DropRelFileNodeBuffers, tas

On 1 June 2012 12:34, Sergey Koposov <koposov@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