Michael Paquier - PostgreSQL committer

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

PostgreSQL 9.2 highlight - Index-only scans

2012-06-08 02:43:49 +0000

PostgreSQL 9.2 introduces a new performance feature called Index-Only scans, which was really something missing in core for performance of scan index. Here is the commit that introduced the feature in core.

Read more...

First steps with dblink on Postgres

2012-06-01 07:50:39 +0000

This short manual targets PostgreSQL users looking for a smooth introduction to dblink.

Read more...

Start a Postgres-XC cluster in (more or less) 10 commands

2012-05-26 02:32:14 +0000

First you need to download the latest version of Postgres-XC from here.

Read more...

Rules in Postgres-XC

2012-05-09 00:16:48 +0000

One of the features that has been really improved the last couple of weeks is the stabilization of remote query planning for DML for Postgres-XC standard planner. And this has consequences on rules, because a rule is fired on Coordinators by design, and you need to provide a global way to plan queries correctly with remote nodes. Just to recall, a rule is the possibility to define an alternative action when doing an INSERT, UPDATE or DELETE on a table. Another important point is that the query of a rules is not planned at the moment of the rule creation, but after rule is fired, however it doesn’t change the fact that a correct query planning is needed at a moment or another.

Read more...

Postgres-XC tutorial at PGCon 2012 - What do YOU want to see?

2012-04-20 02:06:47 +0000

This year, Postgres-XC has a tutorial at PGCon. Yeah. Based on the schedule of PGCon 2012, XC team has 3 hours to make you masters of this cluster based on PostgreSQL.

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 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 Next »

Search

Social

Github

Mastodon

Twitter

RSS Feeds

Main

Postgres

Sponsor

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.