Hi Greg,
On Tuesday 19 January 2010 15:52:25 Greg Stark wrote:
> On Mon, Jan 18, 2010 at 4:35 PM, Greg Stark wrote:
> > Looking at this patch for the commitfest I have a few questions.
>
> So I've touched this patch up a bit:
>
> 1) moved the posix_fadvise call to a new fd.c function
> pg_fsync
On Monday 28 December 2009 23:59:43 Andres Freund wrote:
> On Monday 28 December 2009 23:54:51 Andres Freund wrote:
> > On Saturday 12 December 2009 21:38:41 Andres Freund wrote:
> > > On Saturday 12 December 2009 21:36:27 Michael Clemmons wrote:
> > > > If ppl think its worth it I'll create a tick
On Tuesday 29 December 2009 11:48:10 Greg Stark wrote:
> On Tue, Dec 29, 2009 at 2:05 AM, Andres Freund wrote:
> > Reads Completed:2,8KiB Writes Completed: 2362,
> > 29672KiB New:
> > Reads Completed:0,0KiB Writes Completed: 550,
> > 5960KiB
>
>
On Tue, Dec 29, 2009 at 2:05 AM, Andres Freund wrote:
> Reads Completed: 2, 8KiB Writes Completed: 2362,
> 29672KiB
> New:
> Reads Completed: 0, 0KiB Writes Completed: 550,
> 5960KiB
It looks like the new method is only doing 1/6th as much i/o. Do
On Tuesday 29 December 2009 00:06:28 Tom Lane wrote:
> Andres Freund writes:
> > This speeds up CREATE DATABASE from ~9 seconds to something around 0.8s
> > on my laptop. Still slower than with fsync off (~0.25) but quite a
> > worthy improvement.
>
> I can't help wondering whether that's real o
On Tuesday 29 December 2009 00:06:28 Tom Lane wrote:
> Andres Freund writes:
> > This speeds up CREATE DATABASE from ~9 seconds to something around 0.8s
> > on my laptop. Still slower than with fsync off (~0.25) but quite a
> > worthy improvement.
> I can't help wondering whether that's real or s
Andres Freund writes:
> This speeds up CREATE DATABASE from ~9 seconds to something around 0.8s on my
> laptop. Still slower than with fsync off (~0.25) but quite a worthy
> improvement.
I can't help wondering whether that's real or some kind of
platform-specific artifact. I get numbers more l
On Monday 28 December 2009 23:54:51 Andres Freund wrote:
> On Saturday 12 December 2009 21:38:41 Andres Freund wrote:
> > On Saturday 12 December 2009 21:36:27 Michael Clemmons wrote:
> > > If ppl think its worth it I'll create a ticket
> >
> > Thanks, no need. I will post a patch tomorrow or so.
>
