Re: ice-broker scan thread

From: David Boreham <david_list(at)boreham(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: ice-broker scan thread
Date: 2005-11-29 15:01:30
Message-ID: 438C6D4A.4000103@boreham.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-11-29 15:04:07 Re: Using multi-row technique with COPY
Previous Message Mario Weilguni 2005-11-29 14:56:30 Re: Hashjoin startup strategy (was Re: Getting different number of results when using hashjoin on/off)