Re: Slow count(*) again... - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: Slow count(*) again...
Date
Msg-id 4CB422C102000025000367F7@gw.wicourts.gov
Whole thread Raw
In response to Re: Slow count(*) again...  (Neil Whelchel <neil.whelchel@gmail.com>)
List pgsql-performance
Neil Whelchel <neil.whelchel@gmail.com> wrote:

> What is the best method to make a page of results and a list of
> links to other pages of results?

For our most heavily used web app we decided to have the renderer
just read the list of cases and render the pages to disk, and then
present the first one.  We set a limit of 500 entries on the list;
if we get past 500 we put up a page telling them to refine their
search criteria.  That won't work for all circumstances, but it
works well for out web app.

-Kevin

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Slow count(*) again...
Next
From: Mladen Gogala
Date:
Subject: Re: Slow count(*) again...