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...
COUNT(*)
Are you sure you want to hide this comment? It will become hidden in your post, but will still be visible via the comment's permalink.
Hide child comments as well
Confirm
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
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...