Re: [HACKERS] Extended Prefetching using Asynchronous IO - proposal and patch

2014-08-24 Thread johnlumby
Thanks for the replies and thoughts. On 08/19/14 18:27, Heikki Linnakangas wrote: On 08/20/2014 12:17 AM, John Lumby wrote: I am attaching a new version of the patch for consideration in the current commit fest. Thanks for working on this! Relative to the one I submitted on 25 June in bay17

Re: [HACKERS] Extended Prefetching using Asynchronous IO - proposal and patch

2014-05-31 Thread johnlumby
On 05/31/14 20:44, johnlumby wrote: On 05/30/14 09:36, Claudio Freire wrote: Good point. I have included the guts of your little test program (modified to do polling) into the existing autoconf test program that decides on the #define USE_AIO_ATOMIC_BUILTIN_COMP_SWAP. See config/c

[HACKERS] Re: proposal and patch : support INSERT INTO...RETURNING with partitioned table using rule

2012-09-22 Thread johnlumby
On 09/20/12 16:34, Tom Lane wrote: John Lumby writes: On Fri, 22 Jun 2012 09:55:13, Robert Haas wrote: I do notice that the RETURNING clause of the INSERT can't reference NEW, which seems like a restriction that we probably ought to lift, but it doesn't seem to have much to do with your patch.

[HACKERS] prefetching and asynchronous io

2012-09-10 Thread johnlumby
On 08/18/2012 10:11 AM, John Lumby wrote: > I've recently tried extending the postgresql prefetch mechanism on linux to use the posix (i.e. librt) aio_read and friends where possible. In other words, in PrefetchBuffer(), try getting a buffer and issuing aio_read before falling back to fpo

[HACKERS] asynchronous disk io (was : tuplesort memory usage)

2012-08-17 Thread johnlumby
Date: Fri, 17 Aug 2012 00:26:37 +0100 From: Peter Geoghegan To: Jeff Janes Cc: pgsql-hackers Subject: Re: tuplesort memory usage: grow_memtuples Message-ID: On 27 July 2012 16:39, Jeff Janes wrote: >> Can you suggest a benchmark that will usefully exercise this patch? > > I think th