Postgres Pro
Downloads
Home   >   mailing lists

Re: [PERFORM] Delete, foreign key, index usage - Mailing list pgsql-performance

From Tomas Vondra
Subject Re: [PERFORM] Delete, foreign key, index usage
Date
Msg-id 54e42679-7ec5-b097-db7b-f04c9abfc3c6@2ndquadrant.com
Whole thread Raw
In response to Re: [PERFORM] Delete, foreign key, index usage  (Johann Spies <johann.spies@gmail.com>)
Responses Re: [PERFORM] Delete, foreign key, index usage  (Johann Spies <johann.spies@gmail.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Johann Spies
Date:
Subject: Re: [PERFORM] Delete, foreign key, index usage
Next
From: Andres Freund
Date:
Subject: [PERFORM] Questionaire: Common WAL write rates on busy servers.