Re: Performance issue after creating partitions

From: Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Performance issue after creating partitions
Date: 2022-08-25 02:55:04
Message-ID: 2bb350ef-2d9f-60b3-e41a-838b50f94304@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message liam saffioti 2022-08-25 03:43:52 temp files size and count
Previous Message rh 2022-08-25 02:25:47 patroni rhel7.x86_64 RPM package spec issue