Commit Graph

5355 Commits (unified-planner/primary-key-joins)

Author SHA1 Message Date
Nils Dijk 39677cd9a4
fix check for outer rel to take mapped varno's into account 2021-11-10 16:51:58 +01:00
Nils Dijk 827fe6feef
implement parameterized inner loops 2021-11-09 19:12:09 +01:00
Nils Dijk 714eaee44a
disable postgis dependency 2021-11-09 14:30:29 +01:00
Nils Dijk 86f5b38a16
make compatible with pg14 2021-11-09 14:30:29 +01:00
Nils Dijk 2b3c6a2bdd
use patternmatcher for join pushdown 2021-11-09 14:30:28 +01:00
Nils Dijk 372de2f16c
remove liblwgeom from dependencies in citus 2021-11-09 14:30:28 +01:00
Nils Dijk 74ee7adc26
rewriting tree to distributed plan 2021-11-09 14:30:28 +01:00
Nils Dijk 437cdfa36c
more simplification and removal of unused code 2021-11-09 14:30:28 +01:00
Nils Dijk 08413832b7
generic way of matching fields for Var/Const 2021-11-09 14:30:28 +01:00
Nils Dijk 7e8a5804ac
rework the capture logic 2021-11-09 14:30:28 +01:00
Nils Dijk 0ed176693e
collapse closing braces as suggested by dim 2021-11-09 14:30:27 +01:00
Nils Dijk c6660d3b82
formatting and cleanup 2021-11-09 14:30:27 +01:00
Nils Dijk e745576857
prototype of pattern matcher 2021-11-09 14:30:27 +01:00
Nils Dijk 78c9802d9c
basic geo partitioning planning 2021-11-09 14:30:27 +01:00
Nils Dijk 03d2dc9e71
add sql script to initialize a geo distributed table 2021-11-09 14:30:26 +01:00
Nils Dijk 0c60449d08
expand shard model for geo distribution 2021-11-09 14:30:24 +01:00
Nils Dijk a7f30003a1
update pg and citus 2021-11-09 14:29:39 +01:00
Nils Dijk 695cc48cc2
add broadcast optimization rule 2021-11-09 14:29:39 +01:00
Nils Dijk f1d26e5bda
easily add new join optimization functions 2021-11-09 14:29:39 +01:00
Nils Dijk 158bd86e71
fix subtle bug in adding to a list we are iterating over 2021-11-09 14:29:39 +01:00
Nils Dijk 547f0a57c9
add paths for joins instead of rewriting them 2021-11-09 14:29:38 +01:00
Nils Dijk d5e8bda888
fix refactor and renames 2021-11-09 14:29:38 +01:00
Nils Dijk 1f97b5443a
fix targetlist to prevent projection that failed 2021-11-09 14:29:38 +01:00
Nils Dijk 57842ef81e
simple group by push down 2021-11-09 14:29:38 +01:00
Nils Dijk 47138eca8c
propagate partition value during joins 2021-11-09 14:29:38 +01:00
Nils Dijk 9b92976c4a
implement beginning of shard pruning 2021-11-09 14:29:37 +01:00
Nils Dijk debe639b4d
Add support for optimising nested loop a bit (primary key lookup). 2021-11-09 14:29:37 +01:00
Nils Dijk 38c1f0d32f
Fix misread of colocation id 2021-11-09 14:29:37 +01:00
Nils Dijk ab701669f4
Implement beginnings of join pushdown 2021-11-09 14:29:37 +01:00
Nils Dijk 0563201319
Record the colocation id on the DU 2021-11-09 14:29:37 +01:00
Nils Dijk 37721ef0cd
Define a custom path structure 2021-11-09 14:29:37 +01:00
Nils Dijk cb5d6e038c
Remove RTE reference from DU 2021-11-09 14:29:36 +01:00
Nils Dijk 174713fba9
Use path object to recreate range table entry etc 2021-11-09 14:29:36 +01:00
Nils Dijk a4ec8516fa
move path based planner to its own files 2021-11-09 14:29:36 +01:00
Nils Dijk a8097ab28d
hacky hack for double distributed join 2021-11-09 14:29:36 +01:00
Nils Dijk ff81b0b77f
support multiple remote scans 2021-11-09 14:29:36 +01:00
Nils Dijk d7e50170a9
recreate query struct for sub paths 2021-11-09 14:29:35 +01:00
Nils Dijk 7304f2c21e
beginning of set_rel_pathlist_hook to plan query on distributed table 2021-11-09 14:29:34 +01:00
Önder Kalacı 6f5a343ff4
Make sure that enterprise tests pass (#5451) 2021-11-08 18:11:19 +03:00
Önder Kalacı 98ca6ba6ca
Allow lock_shard_resources to be called by the users with privileges (#5441)
Before this commit, we required the user to be owner of the shard/table
in order to call lock_shard_resources.

However, that is too restrictive. We can have users with GRANTS
to the table who are not owners of the tables/shards.

With this commit, we allow such patterns.
2021-11-08 15:36:51 +01:00
Hanefi Onaldi db613b2f5c
Merge pull request #5448 from citusdata/changelog-9.5.10 2021-11-08 16:50:12 +03:00
Hanefi Onaldi 7b63edfc83
Add changelog entries for 9.5.10 2021-11-08 16:41:47 +03:00
Önder Kalacı 3bce4d76d3
Merge pull request #5405 from citusdata/simplify_executor_locks
Simplify/Unify executor locks
2021-11-08 13:58:11 +01:00
Onder Kalaci d5e89b1132 Unify distributed execution logic for single replicated tables
Citus does not acquire any executor locks for shard replication == 1.
With this commit, we unify this decision and exit early.
2021-11-08 13:52:20 +01:00
Hanefi Onaldi 20f3248b6e
Merge pull request #5445 from citusdata/changelog-9.5.9 2021-11-08 14:09:53 +03:00
Hanefi Onaldi 3d49cbf9ab
Add changelog entries for 9.5.9 2021-11-08 13:19:10 +03:00
Önder Kalacı 65911ce162
Merge pull request #5397 from citusdata/naisila/fix-partitioned-index
Run fix_partition_shard_index_names after each wrong naming command
2021-11-08 11:09:08 +01:00
Önder Kalacı d5b371b2e0
Merge branch 'master' into naisila/fix-partitioned-index 2021-11-08 10:53:16 +01:00
Marco Slot 7f162ba834
Merge pull request #5444 from citusdata/marcocitus/remove-master_append_table_to_shard 2021-11-08 10:49:17 +01:00
naisila 385ba94d15 Run fix_partition_shard_index_names after each wrong naming command 2021-11-08 10:43:34 +01:00