Скачать или смотреть Scaling Postgres Episode 143 MS SQL Server Compatible | Time Series Perf | Feature Casualties | BLOB

To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episo...

In this episode of Scaling Postgres, we discuss Microsoft SQL server compatibility, the performance of time series DBs, DB feature casualties and how to clean up BLOBs.

Want to learn more about Postgres performance?
Join my FREE mini-course called the PostgreSQL Performance Starter Kit here: https://www.scalingpostgres.com/cours...

Timestamps:
00:00 - Intro
00:27 - AWS announces Babelfish: open source Postgres with SQL Server compatibility
02:08 - Want more PostgreSQL? You just might like Babelfish
02:27 - TimescaleDB vs. Amazon Timestream: 6000x higher inserts, 5-175x faster queries, 150x-220x cheaper
04:02 - Feature Casualties of Large Databases
07:14 - BLOB cleanup in PostgreSQL
10:10 - Infographic: 5 Things to Include on Your PostgreSQL Security Checklist
10:49 - Running PgBouncer on AWS Elastic Container Service
12:21 - How pgBackRest is Addressing Slow PostgreSQL WAL Archiving Using Asynchronous Feature
14:47 - Replacing Lines of Code with 2 Little Regexs in Postgres
16:25 - Deploy Pgpool-II on Kubernetes to Achieve Query Load Balancing and Monitoring
16:56 - Evolution of tree data structures for indexing: more exciting than it sounds
17:20 - PostGIS Trajectory: Space plus Time
17:50 - 2020 PG Asia Conference Ended Successfully at an Unprecedented Scale!
18:06 - Stéphane Schildknecht
18:18 - Outro

#postgres #postgresql