Jason Petersen

What makes recovering from a failed `COPY` trigger difficult? I believe we were careful to output the number of rows copied, which should allow a caller to resume at a...

Yeah let's move there.

> Since this function is available on the workers, and is deterministic based on the value of the existing row and the new HLL value to be added, there shouldn't...

> Is there a hard limitation preventing pg_shard from dispatching modifications for non-constant expressions? At the moment, yes. `pg_shard` performs `UPDATE`s by grabbing a lock for a shard and updating...

Streaming replication replicates the entire database which is incompatible with our use of many small ["logical" shards](http://www.craigkerstiens.com/2012/11/30/sharding-your-database/). Because of this we've been keeping an eye on BDR/UDR, but don't have...

Hm… so I just checked `hll_add` and it is [also listed as `IMMUTABLE`](https://github.com/aggregateknowledge/postgresql-hll/blob/v2.10.0/hll--1.0.sql#L170-L182)… We find the HLL extension very useful for a number of our customers, so I want to...

OK, so I've investigated what's going on here. Previously we had the assumption that `IMMUTABLE` functions would be collapsed into constants during our call to `eval_const_expressions`. Because of that, we...

Range partitioning is commonly brought up in the context of time series data. Specifically, users often wish to define a partition "width" and add new partitions for the "current" data...

To protect against users accidentally hitting a local table when `pg_shard` is not loaded, we could add a trigger to those tables (this could be part of `master_create_distributed_table`'s logic) so...

As for forgetting `CREATE`, this is a little tougher. One of us recently hit it while trying to run `cstore_fdw`'s regression tests when `pg_shard` was also loaded. The `COPY` commands...