In this episode of Scaling Postgres, we discuss how to generate test data, how WAL archiving is faster in PG15, how to set date statistics on a timestamp and how to avoid useless indexes.
Subscribe at https://www.scalingpostgres.com to get notified of new episodes.
Links for this episode:
- https://kmoppel.github.io/2022-12-23-generating-lots-of-test-data-with-postgres-fast-and-faster/
- https://www.percona.com/blog/speed-up-of-the-wal-archiving-in-postgresql-15/
- https://www.cybertec-postgresql.com/en/improving-group-by-with-create-statistics/
- https://mydbanotebook.org/post/too-many-indexes/
- https://www.cybertec-postgresql.com/en/json-logs-in-postgresql-15/
- http://peter.eisentraut.org/blog/2022/12/27/postgresql-hidden-gems
- https://www.softwareandbooz.com/advent-of-code-2022-days-6-10-with-postgresql/
- https://www.crunchydata.com/blog/solving-advent-of-code-2022-using-postgres-day-6
- https://www.crunchydata.com/blog/solving-advent-of-code-2022-using-postgres-day-7
- https://www.crunchydata.com/blog/solving-advent-of-code-2022-using-postgres-day-8
- https://www.crunchydata.com/blog/solving-advent-of-code-2022-using-postgres-day-9
- https://www.crunchydata.com/blog/solving-advent-of-code-2022-using-postgres-day-10
- https://hdombrovskaya.wordpress.com/2022/12/29/pgsql-phriday-004-postgresql-and-software-development/
- https://andreas.scherbaum.la/blog/archives/1127-PGSQL-Phriday-004-PostgreSQL-and-Software-Development.html
- https://www.softwareandbooz.com/database-devops-and-code-management-with-postgresql/
- https://gorthx.wordpress.com/2023/01/06/pgsql-phriday-004-sequence-survey/
- https://blog.rustprooflabs.com/2023/01/postgres-software-development
- https://www.cybertec-postgresql.com/en/union-all-data-types-performance/
- https://pganalyze.com/blog/5mins-postgres-UNION-subquery-pull-up-performance
- https://www.percona.com/blog/transparent-data-encryption-tde/
- https://github.com/michelp/pgsodium
- https://www.percona.com/blog/diffing-postgresql-schema-changes/
- https://www.percona.com/blog/postgresql-vacuuming-to-optimize-database-performance-and-reclaim-space/
- https://www.migops.com/blog/oracle-vs-sql-server-vs-postgresql-date-date-type/
- https://postgrespro.com/blog/pgsql/5969929
- https://postgres.fm/episodes/row-estimates
- https://postgres.fm/episodes/postgres-year-in-review-2022
- https://postgres.fm/episodes/transaction-id-wraparound
- https://postgresql.life/post/lukas_eder/