Home PostgreSQL Notes on the margins of the international conference PGConf.Russia 2020. Highlights and slides

Notes on the margins of the international conference PGConf.Russia 2020. Highlights and slides

by admin

The international conference PGConf.Russia 2020 of all postgressors in Russia and much of the world, this year was hosted by the Faculty of Economics at Moscow State University.
Notes on the margins of the international conference PGConf.Russia 2020. Highlights and slides
Anyone interested in a few highlights of the reports is welcome under the cat.
A general photo of most of the speakers.
Notes on the margins of the international conference PGConf.Russia 2020. Highlights and slides
We take the four best, in my opinion, reports, reserve 5 minutes of patience and we get it!

  • O. Kozlov and M. Tsvetkov New developments for PostgreSQL nonvolatile memory technology.

I’ll put it a little more simply, "How INTEL started taking expansion cards to trade shows, " and the startup Swarm64 is accelerating analytics queries to Postgres. A little funnier, in my memory this is practically the first conference where It wasn’t Mikhalkov who played the tsar. Intel didn’t present a single purely processor or chipset solution. However, wow, the Elbrus processor along with its motherboard was in another wing of the building as part of the general exhibit. Amazing what you do, TSMC!
Notes on the margins of the international conference PGConf.Russia 2020. Highlights and slides
What’s on offer here? In very simple language, Intel has gone on the offensive in NVMe storage systems. In parallel, offering solutions on FPGA systems to accelerate API systems that benefit from being accelerated by splitting actions into multiple parallel threads. This is exactly how the result shown on the slide was achieved. A 1TB base can end up being put into memory and get just chocolate speeds.

  • A. Afinogenov How I stopped worrying and moved 60K lines of code from 150 PL/SQL procedures to Postgres

If you’re going to read it, too, catch the alternate title "How 3 Modern Spartans Automate the Nation’s Railroads and What Happens If Our Managers Find Out."
It was :
Notes on the margins of the international conference PGConf.Russia 2020. Highlights and slides
Should have done and done!
Notes on the margins of the international conference PGConf.Russia 2020. Highlights and slides
Notes on the margins of the international conference PGConf.Russia 2020. Highlights and slides
An example of a creative approach to optimization.
Notes on the margins of the international conference PGConf.Russia 2020. Highlights and slides
Total: in terms of productivity, 3 people have proved that even without much experience, but under the system management of Postgres Pro staff, you can perform miracles of migration. I wish success to such a small but very productive team – they admittedly have at least 15 industrial installations ahead of them.

  • A. Korotkov Bottlenecks of PostgreSQL #2

Postgress bottlenecks, part two. You can’t repeat these experiments at home, but you can in the cloud. How to torment the server with three code fragments.
Notes on the margins of the international conference PGConf.Russia 2020. Highlights and slides
Notes on the margins of the international conference PGConf.Russia 2020. Highlights and slides
Notes on the margins of the international conference PGConf.Russia 2020. Highlights and slides
Notes on the margins of the international conference PGConf.Russia 2020. Highlights and slides
Once again, the experiments were done on relatively serious cloud systems,
with a full understanding of the strength and weakness of the Postgres architecture. There’s a lot to think about.

  • Bruce Momjian Non-Relational PostgresSQL

Nonrelational operators in Postgres.
Notes on the margins of the international conference PGConf.Russia 2020. Highlights and slides
What followed was a detailed summary of several hundred pages of documentation. To Bruce’s credit it was all laid out with great American humor. All the scripts were available for download and experimentation from Bruce’s own site. The address is in the form of a squirrel gnawing on the nuts of knowledge.
Notes on the margins of the international conference PGConf.Russia 2020. Highlights and slides
Afterword. All conference proceedings will be available at conference website In a little while. Enjoy reading everyone! Thanks to the speakers for great, very vital reports!
How a general conference photo was taken.
Notes on the margins of the international conference PGConf.Russia 2020. Highlights and slides

You may also like