#26451: extend Paginator to support infinite pagination and postgres estimated
count
------------------------------+--------------------------------------
Reporter: syphar | Owner: syphar
Type: New feature | Status: new
Component: Core (Other) | Version: 1.9
Severity: Normal | Resolution:
Keywords: | Triage Stage: Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
------------------------------+--------------------------------------
Changes (by syphar):
* needs_better_patch: => 0
* needs_tests: => 0
* needs_docs: => 0
Old description:
> We often have problems with bigger tables and slow {{count(*)}}
> performance.
>
> depending on the use-case there are two ways to improve the situation
> * just work without count, if you never show the page-count. Then the
> paginator can just return empty results if the end is near.
> * use rough estimations for the page-count, perhaps with some security
> margin. For example PostgreSQL supports this by using {{EXPLAIN}}, based
> on the table statistics.
>
> I want to
> * extend the paginator to support both (infinite and estimate)
> * provide an option for {{ModelAdmin}} that let's you use the estimation-
> paginator.
> * or perhaps even support the infinite-paginator, this would also include
> interface changes to the pagination.
New description:
We often have problems with bigger tables and slow {{{count(*)}}}
performance.
depending on the use-case there are two ways to improve the situation
* just work without count, if you never show the page-count. Then the
paginator can just return empty results if the end is near.
* use rough estimations for the page-count, perhaps with some security
margin. For example PostgreSQL supports this by using {{EXPLAIN}}, based
on the table statistics.
I want to
* extend the paginator to support both (infinite and estimate)
* provide an option for {{ModelAdmin}} that let's you use the estimation-
paginator.
* or perhaps even support the infinite-paginator, this would also include
interface changes to the pagination.
--
--
Ticket URL: <https://code.djangoproject.com/ticket/26451#comment:1>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/064.fb15051773421c922de825f14539e857%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
