Importing OpenStreetMap data into PostGIS is time-consuming. Download OpenStreetMap offers two dataset types periodically served as sql dumps.
Most database tables have an artificial numeric primary key, and that number is usually generated automatically using a sequence. […]
The comprehensive JSON support in PostgreSQL is one of its best-loved features. Many people – particularly those with a […]
Oracle to PostgreSQL migration - Lessons learned in building a migration tool. How to avoid errors, null bytes and broken content.
Hello, my name is Pavlo Golub, and I am a scheduler addict. That began when I implemented pg_timetable for PostgreSQL. […]
This post describes when to create indexes, before or after bulk loading of the data. Improve your PostgreSQL performance by doing it right.
PostgreSQL v12 brought more efficient storage for indexes, and v13 improved that even more by adding deduplication of index […]
Last time, we installed PostGIS on top of PostgreSQL. Today, I will show you how to upgrade PostGIS on Ubuntu 20.04.02.
This poem post shows the importance of even one missing index for a target PostgreSQL table from a performance perspective.
This post shows how to deal with out of sync PostgreSQL sequences in underlying tables using open-source pg_sequence_fixer extension
Our team is proud to introduce a new major pg_timetable v4 release! This time a huge amount of work has […]
PostgreSQL vs Redis vs Memcached: How would it look on the performance side, if one just skips the cache & hit the database directly?
