Viewing profile — laurenz_albe

PostgreSQL itself doesn't hire anyone. The trade mark is owned by the "PostgreSQL Community Association of Canada" ( https://www.postgres.ca/ ), which does not hire people or engag…

This seems to be unfounded criticism. When statistics are gathered, PostgreSQL samples a certain percentage of the table, so that obviously scales. The number of "most common value…

That is not what "they" are saying. count(1) and count(*) are equally fast because they are doing the same thing.