Yes, finally! David Fetter wrote, and Heikki Linnakangas committed patch which adds on/off arguments to \timing:
Author: depesz
pgsql-tools/analyze.pgsql.logs.pl
Changes:
- normalize PREPARE … statements
- normalize DEALLOCATE … statements
SVN repo at: http://svn.depesz.com/svn/pgsql-tools/trunk
pgsql-tools/analyze.pgsql.logs.pl
Changes:
- properly handle cases where non-LOG: lines contain “\n"
SVN repo at: http://svn.depesz.com/svn/pgsql-tools/trunk
pgsql-tools/analyze.pgsql.logs.pl
Changes:
- add handling of %i in log_line_prefix
- add handling of [, ], ( and ) in log_line_prefix
SVN repo at: http://svn.depesz.com/svn/pgsql-tools/trunk
Counting number of distinct elements
When I was working for one of customers we found some strange thing. We needed to found number of distinct sessions per day. Table layout was very simple:
Silencing \commands in .psqlrc
I'm using .psqlrc file to set my preferable environment in psql. But I got lately annoyed by it confirming the changes every time I run psql:
Waiting for 8.4 – partial-match support in GIN, and sequence restart
Today we have two interesting patches:
- patch by Teodor Sigaev and Oleg Bartunov, and committed by Tom Lane, which adds interesting capability to GIN indexes
- patch by Zoltan Boszormenyi, also committed by Tom, which adds “RESTART" option to ALTER SEQUENCE. With some interesting consequences
Continue reading Waiting for 8.4 – partial-match support in GIN, and sequence restart
Waiting for 8.4 – CASE in pl/PgSQL
Another patch from Pavel Stehule – committed by Tom Lane. This patch adds CASE construction to pl/PgSQL:
Waiting for 8.4 – function stats
Today another great patch, committed by Tom Lane. This patch was written by Martin Pihlak (with some edits by Tom).
Waiting for 8.4 – pl/PgSQL RAISE
Today we have one new feature – extension of plpgsql's RAISE command.