Re: 9.4 regression - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: 9.4 regression
Date
Msg-id 20130820012757.GT2706@tamriel.snowman.net
Whole thread Raw
In response to Re: 9.4 regression  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: 9.4 regression  (Bruce Momjian <bruce@momjian.us>)
Re: 9.4 regression  (Bruce Momjian <bruce@momjian.us>)
List 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 by date:

Previous
From: Noah Misch
Date:
Subject: Re: Fix Windows socket error checking for MinGW
Next
From: Stephen Frost
Date:
Subject: Re: [PATCH] pg_sleep(interval)