27 Oct
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 More
PostgreSQL
23 Dec
Since version 9.3 PostgreSQL introduced the ability of checksums. The documentation says "Use checksums on data pages to help detect corruption by the I/O system that would otherwise be silent"....
Read More 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 17 Aug
Introduction As you know postgres_fdw extension using to access data stored in external PostgreSQL servers. postgres_fdw provides has more transparent and standards-compliant syntax for accessing remote tables than dblink. Additionaly, this extension provides...
Read More 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 12 Jan
Introduction Recently we were approached by one of our clients with an interesting task. The fact is that he has a large database, around 1.5 TB. He also has several standbys from this...
Read More 06 Dec
OVERVIEW To migrate the data from Oracle to Postgres, we using the utility Ora2Pg. Ora2Pg is a free tool used to migrate an Oracle or MySQL database to a PostgreSQL compatible schema....
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- 1
- 2