[GENERAL] pgbench support dynamic identifier name

2016-11-01 Thread
HI, pgbench can support literal parameter now, so if need different pgbench client thread to support different table name. must use multi script , and set different name in the file. but ,if pgbench can support it , will much better like sysbench. for exp: ``` vi test.sql \set id ra

[GENERAL] postgres_fdw how to pushdown parent table's JOIN

2016-07-24 Thread
PostgreSQL continued in sharding technology fdw based roots, the 9.6 Subject to the conditions set, and JOIN support SORT pushed down to the data node execution. Here is a test Create several shard databases for subfix in 0 1 2 3 do psql -c "create database db $ subfix" done Create a master d