Postgres Pro
Downloads
Home   >   mailing lists

LIMIT: does it cause the query to find all matching sets first? - Mailing list pgsql-general

From Jean-Christian Imbeault
Subject LIMIT: does it cause the query to find all matching sets first?
Date
Msg-id 3D985C8F.9070204@mega-bucks.co.jp
Whole thread Raw
Responses Re: LIMIT: does it cause the query to find all matching sets first?  (Bruno Wolff III <bruno@wolff.to>)
Re: LIMIT: does it cause the query to find all matching sets first?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: LIMIT: does it cause the query to find all matching sets  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Johnson, Shaunn"
Date:
Subject: Errors reloading with pg_dump
Next
From: Tom Lane
Date:
Subject: Re: Beta2 - A Late Announcement