PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> If I execute:
> select * FROM FAC_ITEM WHERE FCODDIST='' AND FSUCURS=1 AND
> FFECHAI=current_date;
> it use only one partition
> but:
> delete FROM FAC_ITEM WHERE FCODDIST='' AND FSUCURS=1 AND
> FFECHAI=current_date;
> scan all partitions
> Is there any regression?
No. There's work afoot to improve this, but it wasn't any better before.
regards, tom lane