LIMIT: does it cause the query to find all matching sets first?

From: Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: LIMIT: does it cause the query to find all matching sets first?
Date: 2002-09-30 14:15:43
Message-ID: 3D985C8F.9070204@mega-bucks.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Does using LIMIT cause query execution to stop as soon as the LIMIT
number of matches have been found, or are *all* the matching rows found
first and then the first LIMIT number are returned?

Of course this would be for a query without and ORDER BY clause.

Jc

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-09-30 14:35:29 Re: Beta2 - A Late Announcement
Previous Message Johnson, Shaunn 2002-09-30 14:00:04 Errors reloading with pg_dump