LIMIT and 6.5

From: Matthew Hagerty <matthew(at)venux(dot)net>
To: pgsql-interfaces(at)postgreSQL(dot)org
Subject: LIMIT and 6.5
Date: 1999-06-05 02:55:00
Message-ID: 4.1.19990604224611.00a838e0@mail.venux.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Greetings,

I was wondering if the new LIMIT command in 6.5 is implemented in such a
way that it does in fact improve query time and memory on large result
sets? I was reading a patch that gives the LIMIT command capability to
6.4.2, but there was a note that indicated that the query processor still
had to evaluate the whole query and only *returns* the indicated number of
tuples/rows. Is that the case with 6.5 also? If so, what is the use of
having such a command if it does not improve performance or save memory?
It is already possible (and easy) to just grab x number of tuples/rows from
a query since most of the time they are fetched in a loop anyway.

Thanks,
Matthew Hagerty

Browse pgsql-interfaces by date

  From Date Subject
Next Message George Henry C. Daswani 1999-06-05 19:33:55
Previous Message Tom Lane 1999-06-04 22:15:37 Re: [INTERFACES] pgsql_perl5 fails to compile