June 29th, 2016 by depesz | Tags: awk, performance, pg_stat_activity, pg_stat_all_tables, pg_stat_database, postgresql, psql, ruby, stats | 3 comments »
Lately at least two people on irc asked questions similar to "how do I know how many queries there are in database, per second?". So, let's see what we can find out.
June 14th, 2016 by depesz | Tags: counter, cron, increment, irc, postgresql, trigger | 22 comments »
Some time ago someone on irc asked about creating fast counters for something (banners I think). I talked with her (him?) about it, but figured, I can as well write a blogpost, so others can use it too.