/pks/lookup?op=stats is really slow

Bug #1250328 reported by Casey Marshall
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
hockeypuck
Fix Committed
Critical
Casey Marshall

Bug Description

SELECT COUNT(*) FROM really_large_table turned out to be slow, go figure! This would be fast to get from the prefix tree though, each node keeps a cumulative count.

Revision history for this message
Casey Marshall (cmars) wrote :

Cheating with the row count estimate from https://wiki.postgresql.org/wiki/Slow_Counting. A regular ANALYZE should make this number accurate enough?

Changed in hockeypuck:
status: Triaged → Fix Committed
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.