Re: 9.4 regression

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: 9.4 regression
Дата
Msg-id 20130820012757.GT2706@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: 9.4 regression  (Andres Freund <andres@2ndquadrant.com>)
Ответы Re: 9.4 regression  (Bruce Momjian <bruce@momjian.us>)
Re: 9.4 regression  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
* Andres Freund (andres@2ndquadrant.com) wrote:
> I vote for adapting the patch to additionally zero out the file via
> write(). In your tests that seemed to perform at least as good as the
> old method... It also has the advantage that we can use it a littlebit
> more as a testbed for possibly using it for heap extensions one day.
> We're pretty early in the cycle, so I am not worried about this too much...

I dunno, I'm pretty disappointed that this doesn't actually improve
things.  Just following this casually, it looks like it might be some
kind of locking issue in the kernel that's causing it to be slower; or
at least some code path that isn't exercise terribly much and therefore
hasn't been given the love that it should.

Definitely interested in what Ts'o says, but if we can't figure out why
it's slower *without* writing out the zeros, I'd say we punt on this
until Linux and the other OS folks improve the situation.
Thanks,
    Stephen

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Noah Misch
Дата:
Сообщение: Re: Fix Windows socket error checking for MinGW
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: [PATCH] pg_sleep(interval)