March 18th, 2010 by depesz | Tags: cte, function, performance, postgresql, procedure, profiling, sproc, stored, stored procedure, trigger, window functions, with | 9 comments »
One database that I am monitoring uses a lot of stored procedures. Some of them are fast, some of them are not so fast. I thought - is there a sensible way to diagnose which part of stored procedure take ...
October 29th, 2009 by depesz | Tags: backlog, cte, plpgsql, postgresql, with, with recursive | 4 comments »
Yesterday on my favorite IRC channel fooqux asked interesting question. I took some more questions, and here is problem description: We have a system which, every 5 minutes, takes a number of tasks to be done. Tasks are uniform. Within 5 ...
On 4th of September Tom Lane committed another great patch. This one is very large, and even after applying - it's has some rough edges. There will be need for additional patches to make the functionality fully robust, but the ...
