Tag: extension
Fixing out-of-sync sequences in PostgreSQL
Creating auto increment columns in PostgreSQL is easy. Simply use two pseudo data types serial and serial8, respectively, then PostgreSQL will automatically take care of your auto increment columns. However, once in a while problems can still occur. Let us take a look and see. Sequences: Avoid manual values To understand the underlying problem, one […]
unaccent: Getting rid of umlauts, accents and special characters
Database people dealing with natural languages are all painfully aware of the fact that encodings, special characters, accents and alike are usually hard to deal with. This is especially true if you want to implement search in a user-friendly way. This post describes the PG extension unaccent. Consider the following example in PostgreSQL: My name […]
pg_permissions: Inspecting your PostgreSQL security system
Security is an important topic. This is not only true in the PostgreSQL world – it holds truth for pretty much any modern IT system. Databases, however, have special security requirements. More often than not confidential data is stored and therefore it makes sense to ensure that data is protected properly. Security first! This blog […]
pg_crash: Making database crashes great again
Some of you might have seen Kaarel Moppel’s talk about pg_crash at pgconfeu 2017 in Warsaw. However, for those who didn’t have the chance to visit this year’s European conference, I decided to come up with a little blog post introducing you to the blessings of our new module. pg_crash and what it is good […]
Joining data from multiple Postgres databases
BY Kaarel Moppel – With the heyday of big data and people running lots of Postgres databases, sometimes one needs to join or search for data from multiple absolutely regular and independent PostgreSQL databases. (i.e., no built-in clustering extensions are in use). The goal is to present it as one logical entity. Think sales reporting […]
pgstrom: PostgreSQL on a GPU with joins
In my previous post I have shared some GPU performance data, which were mostly related to aggregation. Given the information I have found on the pgstrom wiki page, I decided to give joins a try to see how much speed we can gain by offloading some of the work PostgreSQL has to do to the […]
pg_resetxlog: renamed to pg_resetwal, see update in blog
UPDATE September 2023: This feature is now called pg_resetwal, see the PostgreSQL documentation about it here. The blog below will be preserved for reference. See this blog by Laurenz Albe about corrupting databases to read more aboutpg_resetwal. PostgreSQL has proven to be one of the most reliable Open Source databases around. In the past we […]