On Thu, Mar 22, 2007 at 02:24:39PM -0400, Merlin Moncure wrote:
>Tino was saying that rather that build a complete indexing storage
>management solution that lives outside the database, it is better to
>do intelligent session management so that you get the simplicity if a
>two tier client server system but the scalability of a web app.
No, what he was saying was "there's this thing called a cursor". I
thought there was enough information in the original message to indicate
that the author knew about cursors. There are certainly pros and cons
and nuances to different approaches, but Tino's message didn't touch on
anything that specific.
And even if you do use some kind of "intelligent session management",
how many simultaneous cursors can postgres sanely keep track of?
Thousands? Millions? Tens of Millions? I suspect there's a scalability
limit in there somewhere. Luckily I don't spend much time in the web
application space, so I don't need to know. :)
Mike Stone
