Re: slow dropping of tables, DropRelFileNodeBuffers, tas

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: slow dropping of tables, DropRelFileNodeBuffers, tas
Дата
Msg-id 8169.1339077412@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: slow dropping of tables, DropRelFileNodeBuffers, tas  (Sergey Koposov <koposov@ast.cam.ac.uk>)
Ответы Re: slow dropping of tables, DropRelFileNodeBuffers, tas  (Simon Riggs <simon@2ndQuadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: XLog changes for 9.3
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Avoiding adjacent checkpoint records