Tag: PostgreSQL

  1. Beware of upper()/lower() in PostgreSQL

    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 years old, you will be amazed.

  2. 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 per day per IP. Since i got a /20, we've got to multiply 96 rows with 4096 IP-Addresses.