Re: Planner regression in 9.1: min(x) cannot use partial index with NOT NULL - Mailing list pgsql-hackers

From Greg Stark
Subject Re: Planner regression in 9.1: min(x) cannot use partial index with NOT NULL
Date
Msg-id AANLkTi=zBMY2F=WH+BsDpoPGjoCgwTVUb8yMm+gJuh0g@mail.gmail.com
Whole thread Raw
In response to Re: Planner regression in 9.1: min(x) cannot use partial index with NOT NULL  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: Planner regression in 9.1: min(x) cannot use partial index with NOT NULL
List pgsql-hackers
So it's a clever hack that we used to allow the partial indexes to be
used. It relied on the implicit assumption that min(x) and max(x)
where the only values of x where NULL were both NULL.

It would be nice if we were clever enough to support *any* strict
aggregate using partial indexes on WHERE NOT NULL since they'll all
have that property.


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Sync Rep and shutdown Re: Sync Rep v19
Next
From: Tom Lane
Date:
Subject: Re: Planner regression in 9.1: min(x) cannot use partial index with NOT NULL