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: 2008-08-19 21:08:06
Message-ID: 396486430808191408q65addcb3pfd4bd663963c5377@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Edward W. Rouse 2008-08-19 21:16:14 Re: Join question
Previous Message EXT-Rothermel, Peter M 2008-08-19 20:58:47 LIMIT question