PostgreSQL 16 - Detach partition with FK - Error

Hi all, Issue: After upgrading to PostgreSQL version 16.6 from 15. I see a different behavior when detaching partitions with FK. Scenario 1 works on 15 but stopped working on 16.x CREATE TABLE table1 (   enti_id varchar(75) NOT NULL,   archive_dt date NOT NULL DEFAULT '-01-01'::date

maintenance_work_mem impact?

Hi all, I have a table approx. 20GB. I have a create unique index statement. CREATE UNIQUE INDEX testindex_v1 ON testtable1 (test_index); My observations: maintenance_work_mem = 2G max_parallel_workers = '16' The create index completes in 20 minutes. When I change this: maintenance_work_mem =

For loop execution times in PostgreSQL 12 vs 15

Hi all, I am running a simple test and am curious to know why a difference in execution times between PostgreSQL 12 vs PostgreSQL 15. I have this function: CREATE function test() returns int language plpgsql as $$ declare v_number bigint; v_multiplier float = 3.14159; loop_cnt