I finally got around to setting up a new mailserver and i decided to give OpenSMTPD a try. It wasn’t a natural birth, i can tell you that. The switching of the configuration syntax makes for a lot of outdated Google Search results. So…
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…
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…
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…
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…