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:

[mbanck]

The pg_amcheck binary can be run in parallel (-j option), though that might not be an option

[mbanck]

Data checksums are still not on by default, today