Re: Speed Up Offset and Limit Clause - Mailing list pgsql-performance

From PFC
Subject Re: Speed Up Offset and Limit Clause
Date
Msg-id op.s9oandtdcigqcu@nyuu
Whole thread Raw
In response to Re: Speed Up Offset and Limit Clause  ("Christian Paul Cosinas" <cpc@cybees.com>)
List pgsql-performance
> Thread 1 : gets offset 0 limit 5000
> Thread 2 : gets offset 5000 limit 5000
> Thread 3 : gets offset 10000 limit 5000
>
> Would there be any other faster way than what It thought?

    Yeah, sure, use a thread which does the whole query (maybe using a
cursor) and fills a queue with the results, then N threads consuming from
that queue... it will work better.

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: is it possible to make this faster?
Next
From: Mark Kirkwood
Date:
Subject: Re: is it possible to make this faster?