Скачать или смотреть Timeseries Data in Postgres with Updates at PgDay 2020 San Francisco

A talk by G Gordon Worley III.

One of the limiting factors of most timeseries databases is that, in order to get good read performance, they limit your ability to update data. That's fine if your data is an event stream, but if its coming from a pre-aggregated sources it might update past data, for example data about online ad performance updated after click fraud is discovered. In this talk I'll show you how AdStage stores timeseries data in Postgres to allow fast reads and updates using clever scheme design and functions for speed.

G GORDON WORLEY III: Gordon is Head of Operations and SRE at AdStage where he also serves as the company's DBA to support a variety of databases including Cassandra, Redis, Elasticsearch, Datomic, and, of course, Postgres. He also has extensive experience with data modeling and using and abusing databases to meet the high performance demands of the ad tech space.

Conference link: https://postgresql.us/events/pgdaysf2...