Episode 247 Generate Test Data, Faster Archiving, Date Statistics, Useless Indexes

<p>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.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <ul> <li><a href= "https://kmoppel.github.io/2022-12-23-generating-lots-of-test-data-with-postgres-fast-and-faster/"> https://kmoppel.github.io/2022-12-23-generating-lots-of-test-data-with-postgres-fast-and-faster/</a></li> <li><a href= "https://www.percona.com/blog/speed-up-of-the-wal-archiving-in-postgresql-15/"> https://www.percona.com/blog/speed-up-of-the-wal-archiving-in-postgresql-15/</a></li> <li><a href= "https://www.cybertec-postgresql.com/en/improving-group-by-with-create-statistics/"> https://www.cybertec-postgresql.com/en/improving-group-by-with-create-statistics/</a></li> <li><a href= "https://mydbanotebook.org/post/too-many-indexes/">https://mydbanotebook.org/post/too-many-indexes/</a></li> <li><a href= "https://www.cybertec-postgresql.com/en/json-logs-in-postgresql-15/"> https://www.cybertec-postgresql.com/en/json-logs-in-postgresql-15/</a></li> <li><a href= "http://peter.eisentraut.org/blog/2022/12/27/postgresql-hidden-gems"> http://peter.eisentraut.org/blog/2022/12/27/postgresql-hidden-gems</a></li> <li><a href= "https://www.softwareandbooz.com/advent-of-code-2022-days-6-10-with-postgresql/"> https://www.softwareandbooz.com/advent-of-code-2022-days-6-10-with-postgresql/</a></li> <li><a href= "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-6</a></li> <li><a href= "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-7</a></li> <li><a href= "https://www.crunchydata.com/blog/solving-advent-of-code-2022-using-postgres-day-8"> https://www.crunchydata.com/blog/solving-adven