Michael Paquier - PostgreSQL committer

  • About
  • Home
  • Manuals
  • Presentations
  • Projects
  • Resume
  • Tags

Postgres 9.3 feature highlight - JSON data generation

2013-04-03 14:29:21 +0000

Postgres 9.2 has introduced JSON as a server data type. At this point, the data was simply stored on server side with integrated wrappers checking that data had a correct JSON format. It was a good first step in order to store directly JSON data on server side but core features in 9.2 have its limitations in terms of JSON data manipulation and transformation.

Read more...

Postgres 9.3 feature highlight - handling signals with custom bgworkers

2013-03-28 03:13:01 +0000

Similarly to a normal PostgreSQL child process, a custom background worker should be running using a loop that can be interrupted with signals to update a given status or simply exit the process. Two types of signals are handled by custom background workers in the PostgreSQL architecture: SIGHUP and SIGTERM.

Read more...

Hooks in Postgres - super-superuser restrictions

2013-03-21 03:05:27 +0000

PostgreSQL extensibility is awesome. With things like extensions or custom worker backgrounds, there are many ways for a PostgreSQL developer to create modules without having to touch a single line of the core code at all. Among those tools, PostgreSQL contains a set of hooks that can be used to plug customized code at certain points of the server processing. Hooks are not documented at all, so if you want to know more about them you need either to have a look directly at the PostgreSQL code or to read the slides of the presentation about hooks given by Guillaume Lelarge at PGcon 2012. Personally I recommend the latter, Guillaume’s presentation being really good.

Read more...

Postgres 9.3 feature highlight - writable foreign tables

2013-03-14 06:08:34 +0000

A new set of APIs for foreign data wrappers has been added to allow writable operations on foreign sources. This feature has been committed by Tom Lane a couple of days ago.

Read more...

Postgres 9.3 feature highlight - Materialized views

2013-03-08 02:11:14 +0000

PostgreSQL 9.3 comes with a pretty cool feature called materialized views. It has been created by Kevin Grittner and committed by the same person not so long ago.

Read more...

Postgres 9.3 feature highlight - pg_xlogdump

2013-02-27 01:15:23 +0000

pg_xlogdump is a new contrib module introduced in PostgreSQL 9.3 by this commit.

Read more...

Postgres 9.3 feature highlight - postgres_fdw

2013-02-22 01:47:46 +0000

Up to Postgres 9.2, the only foreign data wrapper present in core was file_fdw, allowing you to query files as remote tables. This has been corrected with the addition of a second foreign data wrapper called postgres_fdw. This one simply allows to query foreign Postgres servers and fetch results directly on your local server. It has been introduced by this commit.

Read more...

Postgres contrib module highlight - pageinspect

2013-02-19 00:25:55 +0000

pageinspect is an extension module of PostgreSQL core allowing to have a look at the contents of relations (index or table) in the database at a low level. In the case of PostgreSQL, tuples of a table are stored in blocks of data whose size can be changed with –with-blocksize at configure step. This module is particularly useful for debugging when implementing a new functionality that changes visibility of data like what could do an autovacuum or map visibility feature, or simply to understand the internals of Postgres without having to read much codea .

Read more...

Postgres 9.3 feature highlight - "Hello World" with custom bgworkers

2013-02-12 08:12:07 +0000

Based on my previous experience using custom background workers (new feature of PostgreSQL 9.3), here is more detailed example of bgworker doing a simple “Hello World” in the server logs.

Read more...

Postgres 9.3 feature highlight - server monitoring with pg_isready

2013-02-03 06:23:00 +0000

PostgreSQL 9.3 adds a new feature related to monitoring with the commit below.

Read more...

« 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 Next »

Search

Links

Github

Twitter

RSS Feeds

Main

Postgres

Unless otherwise specified, the contents of this website are (C)Copyright Michael Paquier 2010-2021 and are licensed for use under CC BY-SA 3.0.