DEV Community

Discussion on: October 2nd, 2020: What did you learn this week?

andreligne profile image

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 👏

I also learned how to approximate the number of rows in a large (> 100m rows) table without using COUNT(*):

nickytonline profile image
Nick Taylor

Processing data via an animated gif