Re: Free WAL caches on switching segments

Поиск
Список
Период
Сортировка
От daveg
Тема Re: Free WAL caches on switching segments
Дата
Msg-id 20060213225036.GE23771@sonic.net
обсуждение исходный текст
Ответ на Re: Free WAL caches on switching segments  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: Free WAL caches on switching segments  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-patches
On Mon, Feb 13, 2006 at 02:59:43PM -0500, Bruce Momjian wrote:
> Tom Lane wrote:
> > Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > > Tom Lane wrote:
> > >> More to the point, the utility of the patch remains unproven.
> > >> We are not in the habit of adding OS dependencies on speculation.
> >
> > > He ran tests, though it is speculation because non-caching is a pretty
> > > hard thing to find a benefit from except under low memory situations.
> >
> > Well, the tests (a) didn't show any particularly good speedup, and
> > (b) were not on the platforms that this is speculated to be useful on
> > (ie, those without O_DIRECT).
> >
> > I really don't think that an adequate case has been made for adding
> > a new OS dependency.
>
> Well, I think the patch should be applied, and the submitter does too,
> so unless I hear other votes, it is going in.

I vote no for whatever that is worth.  A "performance" change needs to
actually demonstrate improved performance.  If the change is really
desireable to clean up some messy code, then add it as a cleanup change
without the extra system calls. Otherwise it just adds one more bit of
mystery for future maintainers who may be decieved into thinking that posix
advise calls are important voodoo.

-dg

--
David Gould                      daveg@sonic.net
If simplicity worked, the world would be overrun with insects.

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Free WAL caches on switching segments
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Free WAL caches on switching segments