PL/Proxy 2.1

Operating systemsOS : Windows / Linux / Mac OS / BSD / Solaris
Program licensingScript Licensing : BSD - BSD License
CreatedCreated : Apr 27, 2010
Size downloadDownloads : 15
Program licensing
Thank you for voting...

Main idea is that proxy function will be created with ...

Main idea is that proxy function will be created with same signature as remote function to be called, so only destination info needs to be specified inside proxy function body.
PostgreSQL must be installed for this to work.
The language is similar to plpgsql - string quoting, comments, semicolon at the statements end.
It contains only 4 statements: `CONNECT`, `CLUSTER`, `run` and `SELECT`.
Each function needs to have either `CONNECT` or pair of `CLUSTER` + `RUN` statements to specify where to run the function.
The `SELECT` statement is optional, if it is missing, there will be default query generated based on proxy function signature.
The `RUN` statment is also optional, it defaults to `RUN ON ANY` which means the query will be run random partition.
Most important functions of PL/Proxy by PL/Proxy Development Team:
• PL/Proxy 2.1 functions detect remote functions to be called from their own signature.
• Function can be run on one, some or all members of the cluster.
• If query is executed on several partitions, it will happen in parallel.
• Queries are run in auto-commit mode on the remote server.
• Query parameters are sent separately from query body, thus avoiding quoting/unquoting overhead on both sides.
• If proxy and partition backend versions match, PL/Proxy [plproxy.1.exe] tries to use binary I/O if possible.
Limitations:
• PL/Proxy - 0MB launches connections into each part from each backend, so in heavy-duty environment is necessary to put pooler between PL/Proxy 2.1 and partitions.
News in the current PL/Proxy version:
Features:
• New SPLIT statement to convert incoming array arguments into smaller per-partition arrays
• Cluster can be defined with SQL/MED facilities, instead of old-style plproxy.
Minor fixes:
• Allow to customize location to pg_config via PG_CONFIG make variable.
• Remote errors and notices are now passed upwards with all details. Previously only error message pas passed and notices were ignored.
• Show remote database name in error messages.
• Compatible with Postgres 9. 0.
• Compatible with flex 2. 5. 35+ - it now properly defines it's own functions, so PL/Proxy does not need to do it. Otherwise compilation will fail if flex definitions are hacked (MacOS).
• Rework regests to make them work across 8. 2. . 9. 0 and decrease chance of spurious failures. The encoding test still fails if Postgres instance is not created with LANG=C.
• `make debXY` will create `postgresql-plproxy-X. Y` package.

PL/Proxy 2.1 scripting tags: query, proxy, plproxy, proxy language, query language, run, function, functions, postgresql tool. What is new in PL/Proxy 2.1 software script? - Unable to find PL/Proxy 2.1 news. What is improvements are expecting? Newly-made PL/Proxy 2.2 will be downloaded from here. You may download directly. Please write the reviews of the PL/Proxy. License limitations are unspecified.