Horton

Re: slow dropping of tables, DropRelFileNodeBuffers, tas

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Sergey Koposov <koposov@ast.cam.ac.uk>
Cc: Simon Riggs <simon@2ndQuadrant.com>, Jeff Janes <jeff.janes@gmail.com>, Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>, pgsql-hackers@postgresql.org
Date: 2012-06-07T13:56:52Z
Lists: pgsql-hackers 
Sergey Koposov <koposov@ast.cam.ac.uk> writes:
> On Tue, 5 Jun 2012, Simon Riggs wrote:
>>>> Sounds less good and we'd need reasonable proof it actually did
>>>> anything useful without being dangerous.

>>> Doing an initial unlocked test speeds things up another 2.69 fold (on
>>> top of 3.55 for your patch) for me, with 1GB of shared buffers. That
>>> seems like it should be worthwhile.

>>> How do we go about getting reasonable proof that it is safe?

>> That's enough for me.

Say what?  That's a performance result and proves not a damn thing about
safety.

			regards, tom lane