Comments (3)
It is not allowed by Postgres.
You can create index concurrently on partitions, but not on the parent table. You can maybe do create all of them concurrently and then do a regular create index on the parent table.
from citus.
Since we have thousands of partitions, I will have to implement/debug a script for automation. It would be convenient if such a function was implemented in the Citus.
from citus.
Closing this since Postgres does not provide this feature, Citus can also not provide it. Because Citus is built on top of Postgres. Feel free to report the feature request to Postgres itself. If Postgres implements it then Citus would probably get it automatically.
from citus.
Related Issues (20)
- Citus backup and restore questions HOT 2
- Tables distribution questions HOT 1
- Can't add entry for certificate authentication to pg_dist_authinfo HOT 2
- SQL Error [XX000]: ERROR: cache lookup failed for type 0 with pg auto explain HOT 2
- BUG: can't call parameterized distributed procedures outside an explicit transaction in Citus 12.1.3 (but not 12.1.0?) HOT 3
- Load data to a table but different sum shards size in worker nodes HOT 1
- Patch for adding support for Rocky Linux to rpm.sh HOT 1
- High Availability improvements coming? Use Replicas for reads?
- postgres[495645]: segfault at 0 ip 00007f318b17e1f4 sp 00007ffc7f1b15d8 error 4 in citus.so[7f318b0a4000+ee000] likely on CPU 93 (core 1, socket 1) HOT 5
- PostgreSQL 17 support HOT 1
- wrong one
- Execution order of statements of a transaction HOT 1
- pg_stats_user_tables last_autovacuum for distrubuted tables HOT 3
- Having error while using checkout v4 action in check-sql-snapshots
- Debezium support HOT 2
- [Feature request] Worker nodes read only mode HOT 1
- looks like Issue with MERGE Command. HOT 1
- [doc] wrong code comments for function PopUnassignedPlacementExecution HOT 1
- [Feature question] CDC support in Citus
- `alter_table_set_access_method` AccessExclusiveLock HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from citus.