re: Postgres Is Underrated—It Handles More than You Think VIEW POST

re: Is “forking” count some special operation or just a nice word in place of swearing? Regarding (exact) count, pretty much every system has trouble...

Yes, it's a replacement word, and a reference to "The Good Place" TV series.

And regarding count, no system suffer as much from it as PG. Approximations are rarely an option, and while this challenge is definitely not unique to PG, the PG is doing it worst of all DBMS. Except, maybe, sqlite, and even that I'm not sure.
Such a simple functionality, but can't be implemented properly for more than a dozen of years already. PG's count can be 15x times slower than that of MySQL and 70x slower than Oracle or SQLServer. And that sheet has been there for ages. And is till there.

code of conduct - report abuse