Скачать или смотреть Andrey Borodin. 1) SPQR (Postgres sharding); 2) Data corruption monitoring & troubleshooting

We'll have 2 talks presented by Andrey:

1) SPQR is a lightweight OLTP sharding solution written in Go. In this talk, I'm going to discuss design decisions that led us through FDW-based sharding, CustomNode-based sharding, C-implemented lightweight query routing, and finally to SPQR design.

2) Data corruption monitoring (and some ideas on emergency response: amcheck, etc.)

~~~
About Andrey Borodin: Software engineer, computer scientist, software engineer at Yandex, Ph.D., associated professor at Ural Federal University, co-founder of Octonica company. Researching data indexing since 2008. Teaching at Yandex School for Data Analysis and UrFU. Contributing to PostgreSQL since 2016.
~~~

LINKS:
Slide deck "SPQR – Stateless Postgres Query Router" https://docs.google.com/presentation/...
Slide deck "Data corruption monitoring and emergency action vectors" https://docs.google.com/presentation/...
SPQR https://github.com/pg-sharding/spqr
Citus https://github.com/citusdata/citus
pgcat https://github.com/levkk/pgcat
logerrors https://github.com/munakoiso/logerrors
pg_comment_stats https://github.com/munakoiso/pg_comme...
Amcheck verification of GiST and GIN https://commitfest.postgresql.org/39/...
pg_amcheck https://www.postgresql.org/docs/curre...
pg_checksums https://www.postgresql.org/docs/curre...
pg_checksums for older PG versions https://github.com/credativ/pg_checksums
noisia – harmful workload generator for PostgreSQL https://github.com/lesovsky/noisia