undefined | Better HN

0 pointspestaa13y ago0 comments

Note that recent versions of Postgres can now COUNT against indices so no need to do a full table scan.

0 comments

This certainly helps, but if your indices are several GB in size, even an index scan is a nontrivial expense.

j / k navigate · click thread line to collapse

0 pointspestaa13y ago0 comments

Note that recent versions of Postgres can now COUNT against indices so no need to do a full table scan.

This certainly helps, but if your indices are several GB in size, even an index scan is a nontrivial expense.

j / k navigate · click thread line to collapse