Re: ice-broker scan thread - Mailing list pgsql-hackers

From David Boreham
Subject Re: ice-broker scan thread
Date
Msg-id 438C6D4A.4000103@boreham.org
Whole thread Raw
In response to Re: ice-broker scan thread  ("Pollard, Mike" <mpollard@cincom.com>)
List pgsql-hackers
>threw up some threads to read ahead, then my user thread and my read
>ahead threads would thrash on trying to lock the buffer slots.  So, I
>had the read ahead threads start at some distance into the table, and
>work toward the beginning.  The user thread would do its own I/O until
>  
>
Ah. The lightbulb went on. You want multiple outstanding I/O operations
in the case that table or index spans multiple physical disks.




pgsql-hackers by date:

Previous
From: Mario Weilguni
Date:
Subject: Re: Hashjoin startup strategy (was Re: Getting different number of results when using hashjoin on/off)
Next
From: Tom Lane
Date:
Subject: Re: Using multi-row technique with COPY