Postgres Pro
Downloads
Home   >   mailing lists

Postgres seems to use indexes in the wrong order - Mailing list pgsql-general

From Tim Uckun
Subject Postgres seems to use indexes in the wrong order
Date
Msg-id CAGuHJrNtjab6u5aW75VWciho0pzX+HDPUDyFUUCaWp0jJ6M9Vw@mail.gmail.com
Whole thread Raw
Responses Re: Postgres seems to use indexes in the wrong order
Re: Postgres seems to use indexes in the wrong order
List pgsql-general
Tree view
Take a look at this explain

http://explain.depesz.com/s/TTRN

The final number of records is very small but PG is starting out with a massive number of records and then filtering most of them out.

I don't want to really force pg to always use the same index because in some cases this strategy would win but I am wondering if there is anything I need to do in order to get the planner to make better decisions.

I already did an analyze on the table.

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_upgrade could not connect to server
Next
From: Christophe Pettus
Date:
Subject: Retrieving the role in a logical replication plugin