What’s new in PostgreSQL 10? Part 2 – Native Partitioning
Overview Before version 10, PostgreSQL used inheritance tables as a method for physically partitioning a large table. The inheritance table creates multiple child tables for the parent table and maintains the consistency of data by CHECK constraints and triggers. The application can send requests to the parent table and transparently use the data of the ….Read more
What’s new in PostgreSQL 10? Part 1 – Additional Parallelism.
Introduction All of you know that a new PostgreSQL 10 will soon appear. With this article we begin a series of articles about the most important changes that we believe have appeared in PostgreSQL 10. In PostgreSQL 9.6, developers implement parallel sequential scan, but you had to choose between using parallelism and using your indexes. ….Read more
PostreSQL and RabbitMQ.
Introduction I want to share the experience of using PostgreSQL and RabbitMQ. The matter is that recently we had a question of guaranteed, transactional delivery of messages from DB to the queue of RabbitMQ. In addition, it was required to do this as quickly as possible. I think you are aware of the fact that ….Read more
Separation of the load on PostgreSQL disks
Problem statement Most often, problems with the database are associated with slow disks or with a high load on them. In this moment we don’t have guarantees that all our servers have fast disks. PostgreSQL uses a disk to store not only the user data (tables, indexes, sequences and etc.), but also for storing the service ….Read more
Huge pages and PostgreSQL
Introduction Hugepages is a mechanism that allows the Linux kernel to utilize the multiple page size capabilities of modern hardware architectures. Linux uses pages as the basic unit of memory, where physical memory is partitioned and accessed using the basic page unit. The default page size is 4096 Bytes in the x86 architecture. Hugepages allows ….Read more