jacob.gold

Profile repo.car RSS
Jake Gold @jacob.gold
2023-11-13T04:38:54.760Z
There are 2 million user accounts on Bluesky as of a few minutes ago! 🎉
PostgreSQL query output showing 2000187 accounts on Bluesky
ⱮӠէą @m3ta.uk
2023-11-13T17:34:07.594Z
Want do do a \t before that query and share the time it takes to get results on a highly not recommend count(*)?
Jake Gold @jacob.gold
2023-11-13T17:46:32.685Z
I think it'll be okay 😉
Screenshot "Time: 83.130 ms"
ⱮӠէą @m3ta.uk
2023-11-13T17:48:14.355Z
Luxury! Awesome. 👍❤️
stellz @stellz.xyz
2023-11-13T17:58:50.966Z
count * is faster than you might think even if it’s not “fast”, it’s totally fine to run on tables 10x this size
ⱮӠէą @m3ta.uk
2023-11-13T18:05:23.692Z
You /can/ do it, but it's considered inefficient for... Decades.
Dave Carlson @thecubic.net
2023-11-13T19:49:28.212Z
that just means that understanding is decades obsolete. count(*) is not expensive (absent DBA malpractice or MapReduce)
stellz @stellz.xyz
2023-11-13T18:07:46.613Z
yeah but that’s fine. computers are much faster now. I regularly do this, just not in a user query