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.
Anyone interested in a few highlights of the reports is welcome under the cat.
A general photo of most of the speakers.
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!
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 :
Should have done and done!
An example of a creative approach to optimization.
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.
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.
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.
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.