Re: [HACKERS] What about LIMIT in SELECT ? - Mailing list pgsql-hackers

From Thomas G. Lockhart
Subject Re: [HACKERS] What about LIMIT in SELECT ?
Date
Msg-id 3626ED2F.A0247B01@alumni.caltech.edu
Whole thread Raw
In response to Re: [HACKERS] What about LIMIT in SELECT ?  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
> Your solution really is tailored for this 'partial' query application,
> and I think it is a big need for certain applications that can't use
> cursors, like web apps.  Most other apps have long-time connections to
> the database, and are better off with cursors.

And there are persistant web servers available too, to help work around
this "stateless connection problem"? Let's remember that we are solving
a problem which has few requirements for data integrity, and which is
starting to get out of the realm of Postgres' strengths (almost any
scheme can barf data up to a client if it doesn't care whether it is
repeatable or complete).

Neat stuff though :)

                     - Tom

pgsql-hackers by date:

Previous
From: "Thomas G. Lockhart"
Date:
Subject: Re: [HACKERS] What about LIMIT in SELECT ?
Next
From: Edmund Mergl
Date:
Subject: Re: [HACKERS] perl interface bug?