Re: using CURSOR with PHP

Andrew McMillan writes:
> PostgreSQL will certainly take LIMIT into account when planning queries.

I would think most queries using LIMIT would also include an ORDER BY clause
which would require PostgreSQL to sort all the results before applying the
LIMIT.

> OTOH PostgreSQL does _not_ do result caching, unless you have applied
> some patches that were floating around last year some time.

PostgreSQL might not do 'result caching' but if you have an adequate number
of buffers configured would it not be likely that the results from the last
query are still in memory?

Michael J. Upchurch
Partner2Partner Communications  mike@partner2partner.com  615.286.2199