Re: [GENERAL] Parallel sequential scans

2006-03-24 Thread Jim C. Nasby
On Fri, Mar 24, 2006 at 01:44:19AM -0500, Tom Lane wrote: > > Or I could fire off all the queries simultaneously and hope > > they stay in close-enough lockstep through a single pass > > through the table to be able to share most of the IO. > > I have not tried this sort of thing, but right offhan

Re: [GENERAL] Parallel sequential scans

2006-03-23 Thread Tom Lane
Steve Atkins <[EMAIL PROTECTED]> writes: > I'm doing some reporting-type work with PG, with the vast > majority of queries hitting upwards of 25% of the table, so > being executed as seq scans. > ... > It would be really nice to be able to do all the work with a > single pass over the table, execut

[GENERAL] Parallel sequential scans

2006-03-23 Thread Steve Atkins
I'm doing some reporting-type work with PG, with the vast majority of queries hitting upwards of 25% of the table, so being executed as seq scans. It's a fairly large set of data, so each pass is taking quite a while, IO limited. And I'm looking at doing dozens of passes. It would be really nice