Re: Delete, foreign key, index usage

From: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Delete, foreign key, index usage
Date: 2017-04-24 13:17:18
Message-ID: 54e42679-7ec5-b097-db7b-f04c9abfc3c6@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 04/24/2017 08:48 AM, Johann Spies wrote:
>
> Why would the planner prefer the use the gin index and not the btree
> index in this case?
>

You'll need to show what queries are you running - that's a quite
important piece of information, and I don't see it anywhere in this
thread. Seeing explain plans would also be helpful.

regards

--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andres Freund 2017-04-25 04:17:43 Questionaire: Common WAL write rates on busy servers.
Previous Message Johann Spies 2017-04-24 06:48:56 Re: Delete, foreign key, index usage