Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: LIMIT question
- From: "Richard Broersma" <richard(dot)broersma(at)gmail(dot)com>
- To: "EXT-Rothermel, Peter M" <Peter(dot)M(dot)Rothermel(at)boeing(dot)com>
- Cc: pgsql-sql(at)postgresql(dot)org
- Subject: Re: LIMIT question
- Date: Tue, 19 Aug 2008 14:08:06 -0700
- Message-id: <396486430808191408q65addcb3pfd4bd663963c5377@mail.gmail.com> <text/plain>
On Tue, Aug 19, 2008 at 1:58 PM, EXT-Rothermel, Peter M <Peter(dot)M(dot)Rothermel(at)boeing(dot)com> wrote: > Now I can give some feedback like your search matches 200,000 but was > limited to 1000 items. > Is there a better way to accomplish this goal? Here is a nice discussion on the alternatives open to you: http://www.commandprompt.com/blogs/joshua_drake/2007/08/how_many_rows_do_i_have_anyway/ -- Regards, Richard Broersma Jr. Visit the Los Angeles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug
- Follow-Ups:
- Re: LIMIT question
- From: Tom Lane
- Re: LIMIT question
- References:
- LIMIT question
- From: EXT-Rothermel, Peter M
- LIMIT question
- Prev by Date: LIMIT question
- Next by Date: Re: Join question
- Previous by thread: LIMIT question
- Next by thread: Re: LIMIT question
- Indexes: