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...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...2012-06-01 07:50:39 +0000
This short manual targets PostgreSQL users looking for a smooth introduction to dblink.
Read more...2012-05-26 02:32:14 +0000
First you need to download the latest version of Postgres-XC from here.
Read more...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...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...Unless otherwise specified, the contents of this website are (C)Copyright Michael Paquier 2010-2024 and are licensed for use under CC BY-NC-ND 4.0.