PostgreSQL

Follow the thread. Read the stories.

2020

2019

PostgreSQL custom sorting made easy

Every developer knows the pain of sorting database rows by some custom field. The easiest Example of this are DNS Records. Today i’ve come across a solution using array_position. Basically you can pass it the Order of elements you want…

2011

Beware of upper()/lower() in PostgreSQL

Happy new year to all of you. Today i’m going into performance impacts which can come from upper()/lower(). If you were already aware of these things, you won’t be impressed, but if you’re like me, optimizing your setup which is 5…

2010

IP-Traffic accounting with PostgreSQL-Triggers

So i got this DB-server which does nothing but work out NetFlow files with flow-tools.Since i want that data to be as live as possible for my customers, i’ve decided to go with a 15-minute rotation interval. This leaves me with 96 rows…

PostgreSQL on Github

For everyone who missed it, the PostgreSQL-Team setup a automatic-push repository on GitHub at http://github.com/postgres/postgres additionally to git.postgresql.org. If you want to contribute a patch, don’t try pull request. Instead…