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 1lHPJO-0007ID-LL for pgsql-admin@arkaria.postgresql.org; Wed, 03 Mar 2021 11:05:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lHPJN-0006t1-IM for pgsql-admin@arkaria.postgresql.org; Wed, 03 Mar 2021 11:05:01 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lHPJN-0006st-6Y for pgsql-admin@lists.postgresql.org; Wed, 03 Mar 2021 11:05:01 +0000 Received: from mail-ed1-x52f.google.com ([2a00:1450:4864:20::52f]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lHPJK-0004b3-CN for pgsql-admin@lists.postgresql.org; Wed, 03 Mar 2021 11:05:00 +0000 Received: by mail-ed1-x52f.google.com with SMTP id w9so13197417edt.13 for ; Wed, 03 Mar 2021 03:04:57 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20150623.gappssmtp.com; s=20150623; h=message-id:subject:from:to:cc:date:in-reply-to:references :user-agent:mime-version:content-transfer-encoding; bh=u9q2GIaORRexgfn48EljSEx1EDRqhkgLGu953f829zc=; b=LqpYirK11XJ7FenSlGtzA0tLUn5ZJbg2lvzwVG1HJu3BrERHOuk3q8vtpONb+b4tFN YWICBdlDs3cMULA0WRhL+EQsm+YZSCpw7hQD1bdF2CPwOvaG+sPiYcdgYz027AQOaU74 kaB7MHz1TMZKsZy7LSahB4MPtbFxgBtrMuVVIcvyslx7/fWyeztD65fJNidIqzoHtFPT y4LPbRvwUaz7zs9LRp8KxSrt27bQQetNZelSfDV7I/XwYzmMWwfnTYK1Hinrkthb9PRM W3EfV1F+xv6tvJSzhXkKbfR/NVvTKnLtL0x8tkX+q8kl52idBnrOTysUdkH9aGLDm62+ gYWA== 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:cc:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=u9q2GIaORRexgfn48EljSEx1EDRqhkgLGu953f829zc=; b=YBhvkgLzsh4DQaieM4dhs6OfCdinjquOm1nlkd+oC8Lw0Z+dDnYbhKX3MseCbi0lE1 duF+eXpByol2hUUedcAvVxZKMBwhRO9FobGfwHZ08BnE1sJdFYIztM1/m3zfpExyCa6y IbReujFx6dVTiI6hoVQ1x3M9nQ7muov2jTQDea+NoYbrxOhuYxr/7pmpQxu9foFGZc2C bDQkffYaq9YHMarE7UfpXc1aDyW60Jo4gknHmm9QhTr6doa96n1PBWR24A+KExsE7DNi S0pNatAuxHY0vjj5umbxEqfXwWxTqM0Y1kTkutFnD4ooBHN9mE48ALpJdxiSLmUSskxO 748g== X-Gm-Message-State: AOAM530ouG11McPU8o/St+AFD/bF8Uz/8G/tKaDqald36iKQacpcoa/t d4QJwcDSJlH5SWJSetwsRcS7Xw== X-Google-Smtp-Source: ABdhPJwUomt+N8bxJZUMfFu4CqZZW09ZfDpwwRLAFPzO0FIYbf0zTBYIRYr0rCnpdJ9W69QoGoqmEQ== X-Received: by 2002:a05:6402:312b:: with SMTP id dd11mr6242081edb.149.1614769496313; Wed, 03 Mar 2021 03:04:56 -0800 (PST) Received: from localhost.localdomain (217-149-173-211.nat.highway.telekom.at. [217.149.173.211]) by smtp.gmail.com with ESMTPSA id b21sm14796047ejv.13.2021.03.03.03.04.55 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 03 Mar 2021 03:04:55 -0800 (PST) Message-ID: <60c0034b99baa51101ed9c2f94ed1e54029c6e2c.camel@cybertec.at> Subject: Re: Partition table Creation and Testing using Inherited method From: Laurenz Albe To: dbatoCloud Solution Cc: pgsql-admin@lists.postgresql.org Date: Wed, 03 Mar 2021 12:04:54 +0100 In-Reply-To: References: <7482c0a1ea0dba163e35160b4ee92ffb29052c2c.camel@cybertec.at> 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: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2021-03-03 at 14:31 +0530, dbatoCloud Solution wrote: > Thanks! I understood the problem, But, at this moment it is not possible to > upgrade the DB version (10.13) to 11 or 12 due to a sprint issue. PostgreSQL v10 already has (limited) partitioning support, but I'd rather use that than inheritance partitioning. > Is there any other way to improve the performance? Partitioning typically doesn't improve query performance... Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com