Dynamic tracing with Postgres

2014-07-28 01:44:28 +0000

Postgres has in-core support for [Dynamic tracing] (https://www.postgresql.org/docs/devel/static/dynamic-trace.html), which is the possibility to use an external utility to track specific code path calls and have an execution trace at disposition for further analysis. Enabling this feature can be done when compiling code by specifying –enable-dtrace at [configure] (https://www.postgresql.org/docs/devel/static/install-procedure.html) step. Note as well that on Linux systems you will need systemtap installed (development package for compilation may be needed depending on your platform) to be able to compile code with this support, and extra kernel-level packages like kernel-devel to be able to take traces. In order to check if your installation is able to do dynamic tracing, for example simply run the following “Hello World” command.

Postgres 9.5 feature highlight - Display failed queries in psql

2014-07-19 12:52:43 +0000

Postgres 9.5 is coming up with a new ECHO mode for [psql] (https://www.postgresql.org/docs/devel/static/app-psql.html) that has been introduced by this commit:

Postgres 9.5 feature highlight - IMPORT FOREIGN SCHEMA

2014-07-11 13:47:43 +0000

[IMPORT FOREIGN SCHEMA] (https://www.postgresql.org/docs/devel/static/sql-importforeignschema.html) is a SQL query defined in the SQL specification allowing to import from a foreign source a schema made of foreign tables. Its support has been added in Postgres 9.5 with the following commit:

Postgres 9.5 feature highlight - WHERE clause pushdown in subqueries with window functions

2014-07-04 13:47:29 +0000

Postgres 9.5 is going to improve the performance of subqueries using window functions by allowing the pushdown of WHERE clauses within them. Here is a commit, done during commit fest 1, that is the origin of this improvement:

Postgres 9.5 feature highlight - Tracking processes with cluster_name

2014-06-30 13:51:29 +0000

Here is a small feature that has showed up during the [first commit fest] (https://commitfest.postgresql.org/action/commitfest_view?id=22) of Postgres 9.5 allowing to add complementary information in the process names displayed by a server:

« Prev 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 Next »

Michael Paquier - PostgreSQL committer

Dynamic tracing with Postgres

Postgres 9.5 feature highlight - Display failed queries in psql

Postgres 9.5 feature highlight - IMPORT FOREIGN SCHEMA

Postgres 9.5 feature highlight - WHERE clause pushdown in subqueries with window functions

Postgres 9.5 feature highlight - Tracking processes with cluster_name

Search

Social

RSS Feeds

Sponsor