There are 2 million user accounts on Bluesky as of a few minutes ago! 🎉
Want do do a \t before that query and share the time it takes to get results on a highly not recommend count(*)?
count * is faster than you might think even if it’s not “fast”, it’s totally fine to run on tables 10x this size
You /can/ do it, but it's considered inefficient for... Decades.
that just means that understanding is decades obsolete. count(*) is not expensive (absent DBA malpractice or MapReduce)
yeah but that’s fine. computers are much faster now. I regularly do this, just not in a user query