Hi,
We have recently promoted our Prod DB slave (2TB) to migrate to new
hardware, and upgraded from v9.2.9.21 to 9.5.1.6 using pg_upgrade.
The upgrade went without incident and we have been running for a week, but
the optimizer is ignoring indexes on 2 of our largest partitioned tables
causing v
aviour you report.
Best regards
Nick
> On 27 Jul 2017, at 00:40, Peter Geoghegan wrote:
>
>> On Wed, Jul 26, 2017 at 2:05 PM, Peter Geoghegan wrote:
>>> On Tue, Jul 25, 2017 at 10:34 PM, Nick Brennan wrote:
>>> We've added duplicate indexes and analyzing,
