johto's lair
Wednesday, November 18, 2015
LISTENing connections aren't cheap
›
Recently I used perf to look into what could be the cause for our increased CPU usage on the PostgreSQL server (encouraged by Andres' gr...
2 comments:
Wednesday, February 4, 2015
allas: connection pooling for LISTEN / NOTIFY
›
Lately I've been working on a connection pooler which only supports LISTEN / NOTIFY . The idea is to be able to keep the number of Pos...
Thursday, January 15, 2015
Queues, queues, they all fall down
›
Roughly five years ago I presented a way of pulling items off a queue table using advisory locks. Now that the upcoming 9.5 release is goin...
2 comments:
Thursday, November 6, 2014
PostgreSQL gotcha of the week, week 45
›
Something happened earlier this week (or maybe it was last week, I forget), and I was quite perplexed for a good 30 seconds, so I thought I&...
7 comments:
Thursday, May 8, 2014
PostgreSQL gotcha of the week, week 19
›
local:marko=# create table foo(); CREATE TABLE local:marko=#* insert into foo default values; INSERT 0 1 local:marko=#* create function get...
2 comments:
Thursday, May 1, 2014
Why I consider USING harmful
›
Often on the topic of the different JOIN syntaxes in SQL I mention that I consider ON the only reasonable way to specify JOIN clauses in pro...
6 comments:
Saturday, April 26, 2014
SQL gotcha of the week
›
SELECT 'foo' IN ('foo' 'bar'); ?column? ---------- f (1 row) Be careful out there.
18 comments:
›
Home
View web version