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 1lfyju-0005OF-ML for pgsql-admin@arkaria.postgresql.org; Mon, 10 May 2021 05:45:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lfyjs-0001xq-EY for pgsql-admin@arkaria.postgresql.org; Mon, 10 May 2021 05:45:56 +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 1lfyjr-0001xf-Vy for pgsql-admin@lists.postgresql.org; Mon, 10 May 2021 05:45:56 +0000 Received: from mail-wr1-x430.google.com ([2a00:1450:4864:20::430]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lfyjn-0002ys-Pp for pgsql-admin@postgresql.org; Mon, 10 May 2021 05:45:53 +0000 Received: by mail-wr1-x430.google.com with SMTP id l14so15218440wrx.5 for ; Sun, 09 May 2021 22:45:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20150623.gappssmtp.com; s=20150623; h=message-id:subject:from:to:date:in-reply-to:references:user-agent :mime-version:content-transfer-encoding; bh=UnHq2djgnYMqz0XDXodDbctHxfD5czbl55To4CsW4No=; b=rQouGUKqPNyo/np/102HcprFbzyOh+FwM+9qaHlLDtGEm6xysPUeiTvDhSTbdVVgYM T8J6p68Kc8KgsyRztXW6ILlbbQXY4TC6neatc2z31jQwlI7Toen82FNtdqCu1skrQ3sW 3CXd3xUMvHSlDrE5exOcFD1IcGs/i7hcwbU7+e1lwFWart3UE/wqHTcqUphdgp3wvKEL AfA3X2FRG7RiqEtGD7qjmw2cIYg5TSaiRd+YTpDMCt9I/dAeEafQsOkAqNhyzgRm3Sbr DNq/SU/lUjB5k/iP4uzoR4AQKT/ClOMjv813D10n99EoKBPQj/YenASFN4ZixGnpCOLQ vreQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=UnHq2djgnYMqz0XDXodDbctHxfD5czbl55To4CsW4No=; b=i7YDcQEML6Np4OM1zd/ONGoUBiSwDvIGrLSCZK4ZDVNS72D6u16wVqhVhI2XEQJSrp akCE789mjihmV4iYIO0w7M6gDH/pYTGmguN6XYFM9yz/AllBKO37YXmDh79M8BrWYNUf 1tDtHiBXuHEPzS++Zr3+QrObrThTYI6ci4Wu4LzcUZ92HGb0Q62gRRI+gPKZVMIY6shg DI/sZcITaDzPle5YiwmxQJ8C6UxHPmocMmYKi3fIiwn9rly429zfdfZUZnQFvftp/K8f fepXqNE1qkJhpB7f6Ojra6pKmfkGc0+Ng/iU0xctGiFVT0Uy+XmALOgeWzPAqWO4T4N7 C//A== X-Gm-Message-State: AOAM530CjBFlkQgsJvdtl5nIHkdw8TWJl2AUB6I2YWNaApxTNjoqW7vm FYbWiKhyNyFYw03sC4no5BwrvQ== X-Google-Smtp-Source: ABdhPJymHaQecbV9yGFEnikhs9tHkYK21uwU38TiX/cqS5RglgJGsqmpIqaIsWjaXQvUU22vPbag0w== X-Received: by 2002:a5d:6648:: with SMTP id f8mr28937113wrw.396.1620625548627; Sun, 09 May 2021 22:45:48 -0700 (PDT) Received: from localhost.localdomain (mobiledyn-185-69-244-122.mrsn.at. [185.69.244.122]) by smtp.gmail.com with ESMTPSA id x65sm28455777wmg.36.2021.05.09.22.45.48 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sun, 09 May 2021 22:45:48 -0700 (PDT) Message-ID: Subject: Re: Technical guidance for a large partition table From: Laurenz Albe To: John Scalia , pgsql-admin Date: Mon, 10 May 2021 07:45:47 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.36.5 (3.36.5-2.fc32) MIME-Version: 1.0 Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sun, 2021-05-09 at 19:18 -0400, John Scalia wrote: > I have a dev team requesting that I partition 3 very large tables with more 2 billion rows each. > I’ve already got the partition key decided for each with a script which will create a copy of > original with the partition declaration, along with the partition child tables. > [...] > FYI, this is production instance that is regularly updated by field technicians. > Quite literally, I cannot perform two sequential select count(*) from any of these tables > which will return the same row counts.