Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1slVWp-008FgL-Ml for pgsql-hackers@arkaria.postgresql.org; Tue, 03 Sep 2024 15:33:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1slVWn-00DHOK-Ao for pgsql-hackers@arkaria.postgresql.org; Tue, 03 Sep 2024 15:33:09 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1slVWn-00DHO6-15 for pgsql-hackers@lists.postgresql.org; Tue, 03 Sep 2024 15:33:09 +0000 Received: from mail-io1-xd2b.google.com ([2607:f8b0:4864:20::d2b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1slVWk-000TJH-Hb for pgsql-hackers@lists.postgresql.org; Tue, 03 Sep 2024 15:33:07 +0000 Received: by mail-io1-xd2b.google.com with SMTP id ca18e2360f4ac-82a2a035b38so189503339f.0 for ; Tue, 03 Sep 2024 08:33:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1725377585; x=1725982385; darn=lists.postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=ujFHq6RGdMuKL0orqZl4PDto88abkljCNFZgA9rTncM=; b=J0JXEc2bE1LXTO9sevh7H9xV7p0iI15mM4Vw6xKkvn2b2HLmez7o4Fpn94pJfbn8kH oDFg28mocTl0uP2P0OdPrngP5pmyTtRQWaIPoMTIZhWVBBelff23SVj+gdt6yCnLiwaW D/1Tw46grXGyTVWJIDzj7+6zv5a9kZMQCJPWs5VpC+oUE+b2QxCeEri5Q2ccawFSu/ls +/KovdU2O8SKweFRFMI8zthUL4FaTbXrJFEPs5pSOqoiDDt2Uj9GkmzWy++XLVNnDjAV DFWlzi6UpDxGKhejHrDUaJrX1aSx5w/42WXw+z+4M/ciHoXYB5Gfd7/VCXexWD5rRrO4 0/gw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1725377585; x=1725982385; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=ujFHq6RGdMuKL0orqZl4PDto88abkljCNFZgA9rTncM=; b=YzgQA+K1q/q/JY9nSfKY8A/LCARXOGYdqvH635RxKJui9z0R7udt1KqUH3smY8LrjE fJKOsljpKHNpAhATOMfwcavNL1VhEqAIyU4zxE/pflEcf0wjAtTEQx5OzifjlKVULl6X UMTSgQlXNCJj+0APLGD4GcZGPqy8wH4qYDycJp/N3CnqJqvns6iVLXxMc5SK1O65e8jf qjlSVSwP5dWnXQNCNlYCwmbyY9sVelnpQVWdYPJ5qE00UY8E15uxRbkc34kBGjnlk6+t /MB86ayioz3l3OS9kY0WhM+8Ms89i4JOqJw67Swnf3Ewkrcr6uXe5juaccqYMuw5ck5/ R7hQ== X-Forwarded-Encrypted: i=1; AJvYcCUVMUEHsjJ3yLoy3bppMvdFMZixv9oTkbLtUVSyk8z+gyWkBuKNoURZjk72c0GJ13rf3UH/De0L8x9s8QQZ@lists.postgresql.org X-Gm-Message-State: AOJu0YwbUtzVOBRE0koukYc5AAdp9kATKS0S3BliU4NHH2poaKMxFmDR kFJjcwPMWLZ2HuVRqYR4s7eTkdO31fGDe8X93hbmIaH8ecEQ/XhM X-Google-Smtp-Source: AGHT+IFQZtow6X8HabWVEH/KEscIR7rDphi/iYStf8UnHvmQxL5Ceo1u0WDAGBBVCSqxHbQL9NWhWw== X-Received: by 2002:a05:6e02:156f:b0:383:5520:cc48 with SMTP id e9e14a558f8ab-39f4f4bf529mr111212005ab.0.1725377584651; Tue, 03 Sep 2024 08:33:04 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id e9e14a558f8ab-39f5078fb2dsm20674075ab.87.2024.09.03.08.33.04 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 03 Sep 2024 08:33:04 -0700 (PDT) Date: Tue, 3 Sep 2024 10:33:02 -0500 From: Nathan Bossart To: Michael Paquier Cc: "David G. Johnston" , Postgres hackers Subject: Re: Partitioned tables and [un]loggedness Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Sep 03, 2024 at 04:59:18PM +0900, Michael Paquier wrote: > An idea is attached. The pgbench bit was unexpected. This works correctly for CREATE TABLE, but ALTER TABLE still succeeds. Interestingly, it doesn't seem to actually change relpersistence for partitioned tables. I think we might need to adjust ATPrepChangePersistence(). -- nathan