PGConf.Russia interesting takeaways

Last week we were at one of the biggest PostgreSQL events ever held. Nope, it wasn't PGCon, it was the inaugural PGConf.Russia in Moscow. The conference included some very interesting talks. We were especially excited to learn more about several extensions and their potential synergy with pg_shard, CitusDB, and cstore_fdw. We've highlighted a few notable talks below:

• ToroDB, presented by Álvaro Hernández, can be used as a replacement for MongoDB that stores data in PostgreSQL tables. When using cstore_fdw, it can reduce storage size by a factor of 85x compared to MongoDB! We will also explore the possibility of combining ToroDB with CitusDB to build a scalable MongoDB alternative in the coming weeks. Stay tuned.
• Bi-Directional Replication, presented by Simon Riggs, is a sophisticated replication technique coming to PostgreSQL, which should make it much easier to set up multi-master deployments.
• PL/Proxy, presented by Jan Urbański, offers a way of scaling out stored procedures on a master node to many worker nodes, which could prove to be a useful complement to CitusDB and pg_shard.
• Markus Winand presented Modern SQL in PostgreSQL, discussing some of the powerful features in newer SQL standards. It provides some invaluable insights for tuning queries in PostgreSQL.

Of course, we also gave a very well-attended talk on pg_shard. We will discuss the questions and insights that came up during the talk in an upcoming blog post.

• conference talks
• pg_shard
• Postgres

• conference talks
• pg_shard
• Postgres