UPDATE on Domain Array that is based on a composite key crashes

2021-10-19 Thread Onder Kalaci
0010347fbdd postgres`main(argc=, argv=) at main.c:228:3 frame #26: 0x00007fff204e8f3d libdyld.dylib`start + 1 Thanks, Onder KALACI Software Engineer at Microsoft & Developing the Citus database extension for PostgreSQL

ALTER INDEX .. RENAME allows to rename tables/views as well

2021-10-04 Thread Onder Kalaci
Hi hackers, I realized a subtle behavior with ALTER INDEX .. RENAME. It seems like a bug to me, please see the steps below. Test 1: Rename table via RENAME .. INDEX CREATE TABLE test_table (a int); SELECT 'test_table'::regclass::oid; oid --- 34470 (1 row) -- rename table using ALTER INDEX

Re: Combination of geqo and enable_partitionwise_join leads to crashes in the regression tests

2020-10-21 Thread Onder Kalaci
Hi, I think this is already discussed here: https://www.postgresql.org/message-id/flat/CAExHW5tgiLsYC_CLcaKHFFc8H56C0s9mCu_0OpahGxn%3DhUi_Pg%40mail.gmail.com#db54218ab7bb9e1484cdcc52abf2d324 Sorry for missing that thread before sending the mail. From: Onder Kalaci Date: Wednesday, 21

Combination of geqo and enable_partitionwise_join leads to crashes in the regression tests

2020-10-21 Thread Onder Kalaci
Hi, I was running “make installcheck” with the following settings: SET geqo_threshold=2; SET geqo_generations=1000; SETT geqo_pool_size=1000; SET enable_partitionwise_join to true; And, realized that “partition_join” test crashed. It is reproducible for both 12.3 and 13.0 (I’ve not tested furt

Assertion failure with LEFT JOINs among >500 relations

2020-10-08 Thread Onder Kalaci
Hi, I hit an assertion failure. When asserts disabled, it works fine even with more tables (>5000). Steps to reproduce: CREATE TABLE users_table (user_id int, time timestamp, value_1 int, value_2 int, value_3 float, value_4 bigint); 250 relations work fine, see the query (too long to copy &

Re: Looking for a demo of extensible nodes

2019-11-01 Thread Onder Kalaci
Hi, I've a basic experimental extension where I use extensible nodes. This is the commit which adds the extensible node to the project: https://github.com/onderkalaci/pgcolor/commit/10cba5d02a828dbee4bc140f5e88d6c44b40e5c2 Hope that gives you some pointers. On Fri, Nov 1, 2019 at 1:18 PM Adam L