ZSON, PostgreSQL extension for transparent JSONB compression
ZSON is a PostgreSQL extension for transparent JSONB compression. Compression is based on a shared dictionary of strings most frequently used in specific JSONB documents (not only keys, but also values, array elements, etc). In some cases ZSON can save half of your disk space and give you about 10% more TPS.
VIDEO
Слайды
Другие доклады
-
Arthur Zakirov Postgres ProfessionalTeodor Sigaev Postgres Professional
Full text search capabilities in PostgreSQL
Full text search in PostgreSQL is probably the most advanced one among relational DBMS. This tutorial will explain how to setup full text search configurations and dictionaries and how to build a ful text search system using an example of a simple popular science web site, with demonstration of various ranking functions. Also I will tell about new RUM index, which allows to accelerate execution of some kinds of full text queries and implements a new improved ranking function.
-
Michael Kagan Mellanox Technologies
Building high-performance scale-out Database Solutions
Modern high-performance and scale-out Database solutions need to move huge amounts of data between the system components. They need to perform it quickly and without delay for the end-user. While developing interconnect technologies Mellanox focuses on highest bandwidth, ultra-low latency, and advanced CPU offload capabilities. In this session Michael will tell about fast interconnect value for Database and Big Data solutions and will share Mellanox experience in building such systems in cooperation with leading global vendors.
VIDEO
-
Oleg Alekseev МойСклад
Semiautomatic database schema conversion in MoySklad
MoySklad online service includes important component - semiautomatic database conversion framework. Its history and supported conversions are subject of this speech.
VIDEO
-
Nicholas Sivko okmeter.io
PostgreSQL Diagnostics from the standpoint of a system administrator (not a DBA)
It often happens that you already have PosgtreSQL in production, but you don’t have a DBA. To demystify the PostgreSQL database, I’ll tell you how to troubleshoot various problems while working with PosgtreSQL. We will try to understand how to answer "routine" questions of a typical system administrator: - Is everything OK with the database? - What consumes DB server resources? - What to optimize first to reduce resource consumption?
VIDEO