DEV Community

loading...

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

Collapse
andreligne profile image
André

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...

Collapse
nickytonline profile image
Nick Taylor (he/him) Author

Processing data via an animated gif