pg_shard
pg_shard copied to clipboard
citusdata
ATTENTION: pg_shard is superseded by Citus, its more powerful replacement
Someone posted an issue in the repo for pg_partman about not being able to read data from the parent table when used in combination with pg_shard. Haven't been able to...
It would be nice if changes to sharded tables would be propagated automatically to all shards. My understanding right now is that if I alter a table on the master,...
We need a function for dropping all shards of a particular table. Otherwise the process of dismantling a sharded table in order to recreate it can be quite complex.
Now that we've [addressed this in CitusDB](https://www.citusdata.com/blog/20-sumedh/250-announcing-citusdb-41), we want to get it into `pg_shard` as well. We know how to do prepared statements for queries, but `pg_shard` must support modifications...
Currently when attempting to execute a query within a transaction, the following output is produced: ``` ERROR: distributed commands cannot run inside a transaction block ``` Since transactions are not...
@samay-sharma discovered that postgres_fdw does not work when shared_preload_libraries is set to 'pg_shard'. When the instructions on this [link](https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.3#postgres_fdw) is followed for postgres_fdw, we get the following error on _INSERT_...
This ticket is to track full support for the `COPY` command. Unlike the trigger implementation in #61, this would mean supporting a bulk method for data ingestion. Issues like consistency...
Though all (non-side-effecting) functions are safe to execute in a single-shard `SELECT` query, the same is not true for multi-shard SELECTs. In particular, a function such as `random()` or `now()`...
When submitting a query to a worker node that contains `CURRENT_DATE`, the term is translated to `('now'::cstring)::date` which produces the following error on the worker nodes: ``` ERROR: cannot cast...
Though #67 will take care of serious PostgreSQL users, many will prefer to install `pg_shard` using OS package management tools (`apt`, etc.). Many PostgreSQL add-ons are included in Ubuntu's built-in...