Re: slow dropping of tables, DropRelFileNodeBuffers, tas - Mailing list pgsql-hackers

From Tom Lane
Subject Re: slow dropping of tables, DropRelFileNodeBuffers, tas
Date
Msg-id 8169.1339077412@sss.pgh.pa.us
Whole thread Raw
In response to Re: slow dropping of tables, DropRelFileNodeBuffers, tas  (Sergey Koposov <koposov@ast.cam.ac.uk>)
Responses Re: slow dropping of tables, DropRelFileNodeBuffers, tas
List 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


pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: XLog changes for 9.3
Next
From: "Kevin Grittner"
Date:
Subject: Re: Avoiding adjacent checkpoint records