Introduction In the scope of the migration project from Oracle to PostgreSQL, the one of our clients DBA team faced a complicated performance issue. This issue seemed simple at first glance,...
Read MoreIntroduction In the scope of the migration project from Oracle to PostgreSQL, the one of our clients DBA team faced a complicated performance issue. This issue seemed simple at first glance,...
Read MoreOur 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 MoreThis 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 MoreCorrective 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 MoreIntroduction 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 MoreAbout 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 MoreIntroduction 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 MoreIntroduction 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 MoreProblem 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 MoreIntroduction 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