Home > mailing lists

Re: Performance issue after creating partitions - Mailing list pgsql-admin

From	Mladen Gogala
Subject	Re: Performance issue after creating partitions
Date	August 25, 2022 05:55:04
Msg-id	2bb350ef-2d9f-60b3-e41a-838b50f94304@gmail.com Whole thread Raw
In response to	Performance issue after creating partitions (Teja Jakkidi <teja.jakkidi05@gmail.com>)
List	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

From: rh@vonng.com
Date: 25 August 2022, 05:25:47
Subject: patroni rhel7.x86_64 RPM package spec issue

From: liam saffioti
Date: 25 August 2022, 06:43:52
Subject: temp files size and count