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

22 July 2017 by 229 0

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

13 July 2017 by 301 2

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

6 July 2017 by Emil Shkolnik"> 271 0

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

29 June 2017 by 1156 1

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

16 June 2017 by 80 0
Page 3 of 41234