Jason Petersen
Jason Petersen
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...
If a user calls `DROP TABLE` on a `pg_shard`-distributed table, the table is dropped but rows referencing it remain in `pg_distribution_metadata` tables. A solution for this problem was proposed in...
Though `pg_shard` correctly [marks its metadata tables](http://www.postgresql.org/docs/9.4/static/extend-extensions.html#AEN57402) so they are included in the output of `pg_dump`, these dumps are unusable because the `relation_id` column of `pg_shard`'s metadata tables is of...
Not entirely sure whether this is a feature request or a bug report, but various emails have been hitting my inbox of users either: - Putting `pg_shard` in `shared_preload_libraries` but...
I'm sure some bugs could shake out of #137, but for now all the tests are passing and `pg_shard` appears usable under PostgreSQL 9.5alpha2. With this in mind, can we...
Making a query against a table that has been marked as "distributed" (either by `CREATE TABLE ... DISTRIBUTE BY ...` or using `master_create_distributed_table`) which does not yet have any shards...
`pg_shard` keeps a cache of shard interval metadata within each session which is _never_ refreshed. Within `pg_shard` this is fine, since all shards are created up front: caching forever isn't...
#1 and #6 discuss issues around dropping shards (or attempting to use `DROP TABLE`), but there are larger questions around other DDL commands. - [ ] Discuss whether DDL commands...
Certain constraints are unenforceable in a distributed setting: `UNIQUE` indexes foremost among them. `pg_shard` will happily propagate a `UNIQUE` index with nary a peep. The extension should either warn when...
`pg_shard`'s modification logic assumes that any total failure is due to something transient that a retry might overcome. In many cases, an `INSERT` or `UPDATE` could fail due to a...