13 Dec
Our company actively uses pgBouncer. We almost always recommend its use to our customers. This is a really cool connection pooling solution for PostgreSQL. In addition, pgBouncer allows as to...
Read More
postgresql Tag
12 Feb
This post is based on the talk by Oleg Bartunov on pgConf2018.RU It is imperative that a user be able to construct new access methods to provide efficient access to instances of...
Read More 10 Nov
Corrective updates are available for all supported PostgreSQL branches: 10.1, 9.6.6, 9.5.10, 9.4.15, 9.3.20 and 9.2.24, which contain a batch of bug fixes, including fixes for problems that could lead...
Read More 13 Oct
Introduction Not so long ago, one of our customers turned to us with problem. The fact is that PostgreSQL refused to use the index on the text field if you try to...
Read More 06 Oct
About PostGIS PostGIS is an extension to Postgresql that implements the OpenGis standard. PostGIS follows the Simple Features for SQL specification from the Open Geospatial Consortium (OGC). This extension contains extensive functionality for working with spatial...
Read More 22 Jul
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...
Read More 13 Jul
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...
Read More 06 Jul
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...
Read More 29 Jun
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...
Read More 16 Jun
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...
Read More