/pks/lookup?op=stats is really slow
Bug #1250328 reported by
Casey Marshall
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.
To post a comment you must log in.
Cheating with the row count estimate from https:/ /wiki.postgresq l.org/wiki/ Slow_Counting. A regular ANALYZE should make this number accurate enough?