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 1oR31T-0004BM-U1 for pgsql-admin@arkaria.postgresql.org; Thu, 25 Aug 2022 02:55:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oR31S-0005wn-Ou for pgsql-admin@arkaria.postgresql.org; Thu, 25 Aug 2022 02:55:10 +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 1oR31S-0005we-C4 for pgsql-admin@lists.postgresql.org; Thu, 25 Aug 2022 02:55:10 +0000 Received: from mail-qv1-xf2d.google.com ([2607:f8b0:4864:20::f2d]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oR31P-0002B4-O3 for pgsql-admin@lists.postgresql.org; Thu, 25 Aug 2022 02:55:09 +0000 Received: by mail-qv1-xf2d.google.com with SMTP id q8so14371809qvr.9 for ; Wed, 24 Aug 2022 19:55:07 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc; bh=Pxn3QTutTrPpXCXxCCeOCRhSfc9XBEn+qPpAa6ZJsWU=; b=qniSRFLymkgyupDY+bhM2gAca++JH6Fu0qQQjaZLF0VwwGUKqs6trwUuvUWOesGxbD nI31IOFMbY+6/rSMJJxote352lq9Vp1XxQj62b3z7MvXzWLC+KcqGlPaQODZltoeD9oz rHeVQehZMJ7hjibicZ3aEKCVedFu6D99/1z4n6jftPvMnmCcf46GWc8LuIqRRgt7ErrV D1okfslM1i+qGnL/CTR/uD3tNPyXEDQ9RItcz5aRA+SqKJ1ZvpFoArTzA/K6GxQm1ulH trg1K4ODNBofr73ymYaEij5lMjUat5ZA9LJmXeDTUX3uWLKcJszwwqzzyfJWFd/EheQB EA6Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc; bh=Pxn3QTutTrPpXCXxCCeOCRhSfc9XBEn+qPpAa6ZJsWU=; b=oD+G+PCiU5g0+fL1FJMzsvCP9fTH4SgLBtZzVqDqfp014/FGXNgtA+AhGJJT0iKn1Y bTkRKyrb9GAL9GCUY3dVOQa7E8KKx6PtXS6bjVm0OM/lA6QNDERAClfN24fRkioLGEKZ QFZBvA5d3vyLyx6JFgmik1CKHJcAVsV0m2nHCltAqG6HGqniElgOgNoRHApo6wqYEOgk pYl/8jBRaHR9CBafuYlf06nKK9U6BnKnr+d0O1yzX1pkgEphEzILjiyd++0HDSp0oYkT laihw6ftpwX5Fo7au19/XPzbmMf8VQKwif4G/rHztqaZZD01lCtFiM/iIbCIm2JuWIvf azjA== X-Gm-Message-State: ACgBeo3A5tLNH5wAZvSAFh0Rl/XupBEzer/7xIbwy0EPzQviTsSufxtG y4AivcvZ8V9IGcM5WfIxQLMftzpcUSL5MrkA X-Google-Smtp-Source: AA6agR4cJZ0ZfCbDRjk2mOVU4OdlfgGypDX1ttnCSpHvfihAeaA1a4qc7zAZ2RHsWnOzAAWVh0VgwQ== X-Received: by 2002:a05:6214:2a81:b0:473:af82:9a95 with SMTP id jr1-20020a0562142a8100b00473af829a95mr1912593qvb.44.1661396105666; Wed, 24 Aug 2022 19:55:05 -0700 (PDT) Received: from [192.168.2.100] (pool-72-79-30-4.nwrknj.east.verizon.net. [72.79.30.4]) by smtp.gmail.com with ESMTPSA id d23-20020ac851d7000000b00342f6c31da7sm13561256qtn.94.2022.08.24.19.55.05 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 24 Aug 2022 19:55:05 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------Mbfx8GmACUsLb8nb0s3SXOqS" Message-ID: <2bb350ef-2d9f-60b3-e41a-838b50f94304@gmail.com> Date: Wed, 24 Aug 2022 22:55:04 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Thunderbird/91.12.0 Subject: Re: Performance issue after creating partitions Content-Language: en-US To: pgsql-admin@lists.postgresql.org References: <10FAC7AB-09D1-4013-BB3C-79AA3AEDE374@gmail.com> From: Mladen Gogala In-Reply-To: <10FAC7AB-09D1-4013-BB3C-79AA3AEDE374@gmail.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------Mbfx8GmACUsLb8nb0s3SXOqS Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 8/24/22 18:41, Teja Jakkidi wrote: > trunc(order_date) = to_date(’2022-04-01’ You cannot have expression on the left side if you want partition pruning. This is elementary mistake. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com --------------Mbfx8GmACUsLb8nb0s3SXOqS Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit
On 8/24/22 18:41, Teja Jakkidi wrote:
trunc(order_date) = to_date(’2022-04-01’

You cannot have expression on the left side if you want partition pruning. This is elementary mistake.

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com
--------------Mbfx8GmACUsLb8nb0s3SXOqS--