Easy guide to writing PostgreSQL extensions
Learn about PostgreSQL extensions and how to write your own PostgreSQL extensions from scratch.
Fixing out-of-sync sequences in PostgreSQL
This post shows how to deal with out of sync PostgreSQL sequences in underlying tables using open-source pg_sequence_fixer extension
unaccent: Getting rid of umlauts, accents and special characters
Unaccent is a useful PostgreSQL extension for improving user experience. Get insight into this extension and its purpose.
Joining data from multiple Postgres databases
How to join or search data from multiple independent PostgreSQL databases to present it as one logical entity. Here are 4 methods.
pgstrom: PostgreSQL on a GPU with joins
Test of performance using pgstrom with joins in PostgreSQL. Find out how pgstrom performs under different join conditions.