Re: [PERFORM] Speed Up Offset and Limit Clause

Thread 1 : gets offset 0 limit 5000 Thread 2 : gets offset 5000 limit 5000 Thread 3 : gets offset 1 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

Re: [PERFORM] is it possible to make this faster?

Tom Lane wrote: "Merlin Moncure" <[EMAIL PROTECTED]> writes: your time of 150 ms is looking like the slow case on my results. Yeah... so what's wrong with my test? Anyone else care to duplicate the test and see what they get? Using your test [generating c from int(rand(1000))], I get 230 ms