Search

Home > Scaling Postgres > Episode 247 Generate Test Data, Faster Archiving, Date Statistics, Useless Indexes


	Podcast:		Scaling Postgres
	Episode:		Episode 247 Generate Test Data, Faster Archiving, Date Statistics, Useless Indexes
	Category:		Technology
	Duration:		00:14:26
	Publish Date:		2023-01-11 21:47:00
	Description:		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/
	Total Play:		0