Postgres Pro
Downloads
Home   >   mailing lists

Efficiency of LIMIT ? - Mailing list pgsql-hackers

From Chris Bitmead
Subject Efficiency of LIMIT ?
Date
Msg-id 3722CF7A.3FB7A112@bigfoot.com
Whole thread Raw
Responses Re: [HACKERS] Efficiency of LIMIT ?  (Adam Haberlach <haberlaa@ricochet.net>)
List pgsql-hackers
Tree view 
Is the LIMIT feature very efficient? I want to start using it for quite
a few things, but I'm wondering, what happens when I have a zillion
records and I want the first 10, is that going to be an efficient thing
to do?

-- 
Chris Bitmead
http://www.bigfoot.com/~chris.bitmead
mailto:chris.bitmead@bigfoot.com

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: palloc at outer loop?
Next
From: Adam Haberlach
Date:
Subject: Re: [HACKERS] Efficiency of LIMIT ?