2014-11-27 14:27:54 +0000
The extension module [pageinspect] (https://www.postgresql.org/docs/devel/static/pageinspect.html) has been already dumped to version 1.3 in PostgreSQL 9.5 with the addition of functions for [BRIN indexes] (/postgresql-2/postgres-9-5-feature-highlight-brin-indexes/). A couple of days back a new set of functions has been added for GIN indexes with this commit.
Read more...2014-11-20 14:12:26 +0000
A couple of days ago the following feature related to [pg_dump] (https://www.postgresql.org/docs/devel/static/app-pgdump.html) has been committed and will be in Postgres 9.5:
Read more...2014-11-12 08:35:47 +0000
A new index type, called BRIN or Block Range INdex is showing up in PostgreSQL 9.5, introduced by this commit:
Read more...2014-11-06 06:57:47 +0000
Have you ever heard about mpd? It is an open source music player that works as a server-side application playing music, as well as in charge of managing the database of songs, playlists. It is as well able to do far more fancy stuff… Either way, mpd has a set of client APIs making possible to control the operations on server called libmpdclient, library being used in many client applications available in the wild, able to interact with a remote mpd instance. The most used being surely mpc, ncmpc and gmpc. There are as well more fancy client interfaces like for example libmpdee.el, an elisp module for emacs. Now, PostgreSQL has always lacked a dedicated client interface, that’s where [pgmpc] (https://github.com/michaelpq/pg_plugins/tree/master/pgmpc) satisfies this need by providing a set of SQL functions able to interact with an instance of mpd, so you can control your music player directly with Postgres.
Read more...2014-10-31 00:52:34 +0000
Behind this eye-catching title is an [extension] (https://www.postgresql.org/docs/devel/static/extend-extensions.html) called blackhole that I implemented yesterday, tired of needing to always structure a fresh extension when needing one (well copying one from Postgres contrib/ would be fine as well). Similarly to [blackhole_fdw] (https://bitbucket.org/adunstan/blackhole_fdw/src) that is aimed to be an extension for a foreign-data wrapper, blackhole is an extension wanted as minimalistic as possible that can be used as a base template to develop a Postgres extension in C.
Read more...Unless otherwise specified, the contents of this website are (C)Copyright Michael Paquier 2010-2023 and are licensed for use under CC BY-SA 3.0.