Postgres Pro
Downloads
Home   >   mailing lists

Re: [PERFORM] Dissuade the use of exclusion constraint index - Mailing list pgsql-performance

From Adam Brusselback
Subject Re: [PERFORM] Dissuade the use of exclusion constraint index
Date
Msg-id CAMjNa7d_m3XSrD+N1vgHZwcmmXVn2iPVgEQ6RH-kfEgmvaHNHA@mail.gmail.com
Whole thread Raw
In response to Re: [PERFORM] Dissuade the use of exclusion constraint index  (Adam Brusselback <adambrusselback@gmail.com>)
List pgsql-performance
Tree view
Hello all,
Just wondering if there is anything else I can provide to help figure this out.

One thing I did notice, is there is a discussion about "invisible indexes" going on, which seems that if it was implemented, would be one way to "fix" my problem: https://www.postgresql.org/message-id/flat/ed8c9ed7-bb5d-aaec-065b-ad4893645deb%402ndQuadrant.com#ed8c9ed7-bb5d-aaec-065b-ad4893645deb@2ndQuadrant.com

The down side to that approach, is even when that index really is the best option for a query, it cannot utilize it.

Let me know if I can provide anything else.
-Adam

pgsql-performance by date:

Previous
From: Michael Sacket
Date:
Subject: Re: Small query plan change, big performance difference
Next
From: Sasa Vilic
Date:
Subject: Slow query when pg_trgm is in inner lopp