Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lXVbR-0001hU-VY for pgsql-hackers@arkaria.postgresql.org; Fri, 16 Apr 2021 21:02:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lXVbQ-000553-Nm for pgsql-hackers@arkaria.postgresql.org; Fri, 16 Apr 2021 21:02:12 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lXVbQ-00054w-3n for pgsql-hackers@lists.postgresql.org; Fri, 16 Apr 2021 21:02:12 +0000 Received: from mail-oi1-x22b.google.com ([2607:f8b0:4864:20::22b]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lXVbI-000824-EW for pgsql-hackers@postgresql.org; Fri, 16 Apr 2021 21:02:10 +0000 Received: by mail-oi1-x22b.google.com with SMTP id k25so29200916oic.4 for ; Fri, 16 Apr 2021 14:02:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=GIT1oWBjKhEoHOpvZx/CUvI/qcULq3Ub/XFUqy8AAN8=; b=oQ3A50xM/C2eQao/dSbgdrmwIUi+F5qn75bFfkqItP3ny1OQear7XyqXwdyo2NxE+g UM3HlpoLxuiESSdc2/njJ3JbuH+VnfJ9GbEq4nZRSRxWWU48Elv0gDAC267ENh9v4k3o 9lrUke8/WLSyX2oUKGZO+jLNZnKCDvxPM9RD3G/jCYxuh1cbaYQY4rvE1mamTFfCk/Zr AbzT9aBkXDEjUawnICrSQqePIO+YQWj5wuo87NNlcAjP/L2iZugmEpoc3S8kQvFVThWV 2IQWxgchCXxfhnFESMPP4hDov1hQxGxWCZst1vd1990hcsS3l9JSJBxcetmfj8il3EhM FGCg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=GIT1oWBjKhEoHOpvZx/CUvI/qcULq3Ub/XFUqy8AAN8=; b=suRQUzKI/JfxbyKdGsNDDl4pOjWNJPvByF62HxiahsF/hiljk+hwB+umoMhTUVaaL+ iiOyJ3FWULUYi+XOklVPK0pIBjzWRB/paKFgDQvjZZQh52LDN9xpRhgqNHOOI8dYQPzp hzgsjKBhbcN9HvAF7MyeW+TODKcNaHHqry00cdnOKE38azRf76G9Be2k71jrB6gTBWdx ay5qZW+CImQ4a1AHe6/vSjgQV2oyAHrq3RsSmUUAc+I7zkirYoyhw9rUWF9r2OCPQ3pc PoB7RK2nJRu7dy/r10CxstUdf1j1Wfesic7TjsJTM59SRrGtLRezC0s2kCIpy5VLUGLT cdsg== X-Gm-Message-State: AOAM533TqefY8FUyWdEvBBvTNp6kieqMojy1QSqeHnwrBfSLd12HIXj+ RroFxtuj0rAqKIgkRIJDjMkajTrWaGLF9A== X-Google-Smtp-Source: ABdhPJwpS3ck93WW1g2m5sKnE8PR9br9+FBDY7G7aMqMkC4dKU00rsUAE6T66F7JkppW/FD/X4XWsA== X-Received: by 2002:aca:3cd6:: with SMTP id j205mr7813912oia.28.1618606923480; Fri, 16 Apr 2021 14:02:03 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id r136sm1470735oor.28.2021.04.16.14.02.02 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Fri, 16 Apr 2021 14:02:02 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id A9BEC800C82; Fri, 16 Apr 2021 16:02:01 -0500 (CDT) Date: Fri, 16 Apr 2021 16:02:01 -0500 From: Justin Pryzby To: Alvaro Herrera Cc: pgsql-hackers Subject: Re: default_tablespace doc and partitioned rels Message-ID: <20210416210201.GK3315@telsasoft.com> References: <20210416143135.GI3315@telsasoft.com> <20210416201918.GA4771@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20210416201918.GA4771@alvherre.pgsql> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Apr 16, 2021 at 04:19:18PM -0400, Alvaro Herrera wrote: > Maybe we can reword it in some other way. "If this parameter is set > when a partitioned table is created, it will become the default > tablespace for future partitions too, even if default_tablespace itself > is reset later" ...?? +1 I'd say: If this parameter is set when a partitioned table is created, the partitioned table's tablespace will be set to the given tablespace, and which will be the default tablespace for partitions create in the future, even if default_tablespace itself has since been changed. -- Justin