Re:PostgreSQL Count(*) Performance Improvements
by hinkley on Thursday April 11, 2019 @01:39AM
(#19631451)
Not according to that blurb. There have been other databases where count(1) was much faster. Here they are saying that in Postgres, count(1) is slower because star is treated as no arguments, and count(1) is more complex.
[ Parent
| on HN ]
Re:PostgreSQL Count(*) Performance Improvements
by laurenz_albe on Thursday April 11, 2019 @05:31AM
(#19632402)
That is not what "they" are saying. count(1) and count(*) are equally fast because they are doing the same thing.