plproxy

by plproxy

plproxy / plproxy

PL/Proxy development

136 Stars 37 Forks Last release: about 1 month ago (v2.10.0) Other 381 Commits 33 Releases

Available items

No Items, yet!

The developer of this repository has not created any items for sale yet. Need a bug fixed? Help with integration? A different license? Create a request here:

PL/Proxy

PL/Proxy is a PostgreSQL procedural language (PL) handler that allows to do remote procedure calls between PostgreSQL databases, with optional sharding.

Features

Language has four statements:

  • Pick remote database:
    • CLUSTER 
      - use pre-configured cluster that has many databases
    • CONNECT 
      - use connstr directly
  • Set execution type:
    • RUN ON ALL
      - query is run on all databases in parallel
    • RUN ON ANY
      - pick server randomly
    • RUN ON 
      - map hash to database
  • Replace default query:
    • SELECT ...

Example:

CREATE FUNCTION get_user_settings(i_username text) RETURNS SETOF user_settings AS $$
    RUN ON namehash(i_username):
$$ LANGUAGE plproxy;

It will run function with same name in remote database and fetch

user_settings
record.

Installation

For installation there must be PostgreSQL dev environment installed and

pg_config
in the PATH. Then just run:
$ make
$ make install

To run regression tests:

$ make installcheck

Location to

pg_config
can be set via
PG_CONFIG
variable:
$ make PG_CONFIG=/path/to/pg_config
$ make install PG_CONFIG=/path/to/pg_config
$ make installcheck PG_CONFIG=/path/to/pg_config

Note: Encoding regression test fails if the Postgres instance is not created with C locale. It can be considered expected failure then.

We use cookies. If you continue to browse the site, you agree to the use of cookies. For more information on our use of cookies please see our Privacy Policy.