Transactional DDLs – a message to non-PostgreSQL users
In this blog we will talk about transactional DDL's in PostgreSQL vs other database systems. Find out more information.
Functions: The most widely ignored performance tweak
A PostgreSQL function performance can be marked as follows: VOLATILE, STABLE, IMMUTABLE or [NOT] LEAKPROOF. Undestand why.
CREATE TABLE – the fancy way with LIKE
The LIKE keyword: Using LIKE is especially useful if you want to clone tables which have dozens of indexes and constraints.
Kostal Pico to PostgreSQL
As there is hardly code available on the net showing how to access Kostal Pico, I decided to publish this one.
pgbouncer: Proving the point
pgbouncer: Opening and closing a database connection over and over again is not free, but overhead worth thinking about.
GIN - Just A Kind Of Index
GIN stands for Generalized Inverted Index. Find out how data is organized within a PostgreSQL GIN index vs a B-Tree index e.g.
PostgreSQL virtualization revisited
In this blog you can read more about virtualization. This is cool from many points of view but what does it mean for performance?
PostgreSQL 9.3: "One line - one standby"
pg_basebackup for PostgreSQL: You'll see that the call itself already has all the info a user needs to write a simple recovery.conf file.
Better PostgreSQL performance on SSDs
The optimizer uses parameters to optimize queries, which have been constant for years. Do SSD disks have more advantages?
Removing duplicates in PostgreSQL
Today somebody asked me how to remove duplicates which accidentally made it into a table. The problem is: A normal […]