Postgres-XC version 1.1 is out - Mailing list pgsql-advocacy

From Koichi Suzuki
Subject Postgres-XC version 1.1 is out
Date
Msg-id CAFWPvmyBJeuLHQz99K=4wR8y8=2V4Mz+BpTfgouX9RSWCxjF8g@mail.gmail.com
Whole thread Raw
List pgsql-advocacy
Postgres-XC development group is proud to announce the release of Postgres-XC version 1.1.   This is the second major release and comes with many useful features.

Source tarball will be available at http://sourceforge.net/projects/postgres-xc/files/Version_1.1/pgxc-v1.1.tar.gz/download which comes with HTML documentation and man pages.


Please visit the project page http://postgres-xc.sourceforge.net and development page https://sourceforge.net/projects/postgres-xc/ for more materials.

New features of Postgres-XC 1.1 include:

* Node addition and removal while Postgres-XC cluster is in operation.
* Added --restoremode option to pg_ctl to import catalog information from other coordinator/datanode, used when adding new node.
* Added --include-nodes option to pg_dump and pg_dumpall to export node information as well. Mainly for node addition.
* pgxc_lock_for_backup() function to disable DDLs while new node is going to be added and catalog is exported to the new node.
* Row TRIGGER support.
* RETURNING support.
* pgxc_ctl tool for Postgres-XC cluster configuration and operation (contrib module).
* Backup GTM restart point with CREATE BARRIER statement.
* Merged with PostgreSQL 9.2.4.
* ALTER TABLE statement to redistribute tables

Also we have number of improvements in the planner for better performance as:

* Push down sorting operation to the datanodes by using ORDER BY clause in queries to sent to the datanodes.
* Push down LIMIT clause to datanodes.
* Pushdown outer joins to datanodes.
* Improve fast query shipping to ship queries containing subqueries.
* Push GROUP BY clause to the datanodes when there is ORDER BY, LIMIT and other clauses in the query.

It also comes with number of another improvements and fixes.


The group appreciate all the members who provided valuable codes and fruitful discussions.

Best Regards;

--
------
Koichi Suzuki

pgsql-advocacy by date:

Previous
From: "Jonathan S. Katz"
Date:
Subject: Re: Hyderabad, India PUG
Next
From: Josh Berkus
Date:
Subject: What's New in 9.3 Could use some love