Re: tuplesort memory usage: grow_memtuples - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: tuplesort memory usage: grow_memtuples
Date
Msg-id CAEYLb_VuaHP3hNMJkB6fERPwQSsfyeKQ3YO35id0kc3n1N==dg@mail.gmail.com
Whole thread Raw
In response to tuplesort memory usage: grow_memtuples  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: tuplesort memory usage: grow_memtuples
List pgsql-hackers
On 3 March 2012 20:22, Jeff Janes <jeff.janes@gmail.com> wrote:
> Add it all up, and instead of pre-reading 32 consecutive 8K blocks, it
> pre-reads only about 1 or 2 consecutive ones on the final merge.  Now
> some of those could be salvaged by the kernel keeping track of
> multiple interleaved read ahead opportunities, but in my hands vmstat
> shows a lot of IO wait and shows reads that seem to be closer to
> random IO than large read-ahead.  If it used truly efficient read
> ahead, CPU would probably be limiting.

Can you suggest a benchmark that will usefully exercise this patch?

-- 
Peter Geoghegan       http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training and Services


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Synchronous Standalone Master Redoux
Next
From: Alvaro Herrera
Date:
Subject: Re: filenames in pg_basebackup