Skip to content

Instantly share code, notes, and snippets.

@onderkalaci
Last active September 6, 2021 10:19
Show Gist options
  • Save onderkalaci/0a870d95a7c8aaaca6e3a254b5386b82 to your computer and use it in GitHub Desktop.
Save onderkalaci/0a870d95a7c8aaaca6e3a254b5386b82 to your computer and use it in GitHub Desktop.
Citus 10.2
1) Postgres 14 support - https://github.com/citusdata/citus/pull/5209
1.1) Lots of newly supported features, see here for all the new imporovements: https://www.postgresql.org/docs/14/release-14.html
1.2) Major known unsupported PG 14 features on Citus 10.2:
- COPY progress report when COPY dist/ref TO ...
- Re-index partitioned tables: https://github.com/citusdata/citus/pull/5238
- OUT parameters on procedure pushdown delegation - https://github.com/citusdata/citus/pull/5228
- Extended statistics objects on expressions: https://github.com/citusdata/citus/pull/5224
- CTEs with search clause - https://github.com/citusdata/citus/pull/5234
- Postgres' column toast compression on columnar tables: https://github.com/citusdata/citus/pull/5235 -- Onur to review further
2) Timeseries management UDFs - https://github.com/citusdata/citus/pull/5236/files
3) Columnar Btree / Hash indexes, including primary key, unique/exclusion constraints
4) start/stop metadata syncing is transactional - https://github.com/citusdata/citus/pull/5144 / https://github.com/citusdata/citus/pull/5086
5) Metadata syncing uses current user - https://github.com/citusdata/citus/pull/5105
6) Columnar improved support for parametrized execution - https://github.com/citusdata/citus/pull/5172
7) Enable binary encoding by default on PG 14 - https://github.com/citusdata/citus/pull/5242
8) CREATE INDEX ... ON ONLY and ALTER INDEX ... ATTACH PARTITION - https://github.com/citusdata/citus/pull/5115
9) Speeds up dropping partitioned tables: https://github.com/citusdata/citus/pull/5176
10) Bugfixes
- Partitioning & Dropped columns - https://github.com/citusdata/citus/pull/5131
- Memory corruption crash - https://github.com/citusdata/citus/pull/5170
- Prevent deadlocks on concurrent citus_update_table_Statistics / create-drop partitions - https://github.com/citusdata/citus/pull/5155
- avoids epoll_ctl errors (e.g., give proper connection errors or failovers) - https://github.com/citusdata/citus/pull/5158
- Fix issues around UNION / UNION ALL pushdown - https://github.com/citusdata/citus/pull/5079
- Bugfixes around sequences on MX / https://github.com/citusdata/citus/pull/5133 / https://github.com/citusdata/citus/pull/4914 / https://github.com/citusdata/citus/pull/5061
- Partitioned table - foreign keys - common pg_partman issue: https://github.com/citusdata/citus/pull/5191
- Upgrade issues when public schema is dropped - https://github.com/citusdata/citus/pull/5030
- Shard pruning on append/range distributed tables - https://github.com/citusdata/citus/issues/5077
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment