niedziela, 15 listopada 2009

Pgpool-II 2.3 comming soon...

Today Tatsuo Ishii wrote interesting news at pgpool mailing list, version 2.3 coming this month.

What's new in 2.3:


- Adopt PostgreSQL 8.4 parser. On of the visible effects of this is,
WITH clause can be load balanced.

- Allow to use INSERT/UPDATE including CURRENT_TIME_STAMP,
CURRENT_DATE, now(). pgpool-II guarantees that each DB node will be
populated exactly same value for these data type. For example
consider following table:

CREATE TABLE t1(id INTEGER PRIMARY KEY, regdate TIMESTAMP DEFAULT CURRENT_TIMESTAMP);

Let's populate t1:

INSERT INTO t1(id) VALUES(1);

Actual query executed by pgpool-II is:

INSERT INTO "t1"("id", "regdate") VALUES (1,'2009-11-15 21:35:01.783053+09');

'2009-11-15 21:35:01.783053+09' is extraced from PostgreSQL by
executing SELECT CURRENT_TIMESTAP. So t1 tables on all DB nodes has
exactly same value.

- Add new directive log_per_node_statement. If true, print all
statements to the log. Similar to log_statement except that prints
DB node id and backend process id info. Example:

2009-11-15 21:34:12 LOG: pid 22285: DB node id: 0 backend pid: 22301 statement: CREATE TABLE t1(id INTEGER PRIMARY KEY, regdate TIMESTAMP DEFAULT CURRENT_TIMESTAMP);
2009-11-15 21:34:12 LOG: pid 22285: DB node id: 1 backend pid: 22300 statement: CREATE TABLE t1(id INTEGER PRIMARY KEY, regdate TIMESTAMP DEFAULT CURRENT_TIMESTAMP);

Brak komentarzy: