Re: Suspending SELECTs - Mailing list pgsql-performance

From Tino Wildenhain
Subject Re: Suspending SELECTs
Date
Msg-id 43CE0589.3000003@wildenhain.de
Whole thread Raw
In response to Re: Suspending SELECTs  (Alessandro Baretta <a.baretta@barettadeit.com>)
List pgsql-performance
Alessandro Baretta schrieb:
> mark@mark.mielke.cc wrote:
>
...
>
> It looks like this is the only possible solution at present--and in the
> future, too--but it has a tremendouse performance impact on queries
> returning thousands of rows.
>
Well actually one of the better solutions would be persistent cursors
(and therefore connection pooling). I bet this is easier then
fiddling with the problems of offset/limit and inventing even more
compex caching in the application.

Just my 0.02c
++Tino

pgsql-performance by date:

Previous
From: Alessandro Baretta
Date:
Subject: Re: Suspending SELECTs
Next
From: Alessandro Baretta
Date:
Subject: Re: Suspending SELECTs