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
Sampling in PostgreSQL
Sometimes there are situations when you need to select a certain number of random entries from the table. Since version 9.5, this feature has appeared. Using TABLESAMPLE, you can not select all the data from the table, but only some of them. Synopsis: SELECT […] FROM table_name TABLESAMPLE sampling_method ( argument [, …] ) [ ….Read more