I started looking into using partitions in PostgreSQL 12 to improve executing slow queries on large tables. Also that the PostgreSQL project has really excellent documentation, props to them 👏 postgresql.org/docs/12/ddl-partiti...
I'm a fan of Open Source and have a growing interest in serverless and edge computing. I'm not a big fan of spiders, but they're doing good work eating bugs. I also stream on Twitch.
I started looking into using partitions in PostgreSQL 12 to improve executing slow queries on large tables. Also that the PostgreSQL project has really excellent documentation, props to them 👏 postgresql.org/docs/12/ddl-partiti...
I also learned how to approximate the number of rows in a large (> 100m rows) table without using
COUNT(*)
: dev.to/andreligne/counting-large-t...