Re: Delete, foreign key, index usage

From: Johann Spies <johann(dot)spies(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Delete, foreign key, index usage
Date: 2017-04-05 10:40:21
Message-ID: CAGZ55DRr=wVHJgfrBb9eGVWyL81ObJw=7kpfxpfYyeS4osTKmw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 4 April 2017 at 14:07, Johann Spies <johann(dot)spies(at)gmail(dot)com> wrote:

> Why would that be?

To answer my own question. After experimenting a lot we found that
9.6 uses a parallel seqscan that is actually a lot faster than using
the index on these large tables.

This, to us was a surprise!

Regards
Johann

--
Because experiencing your loyal love is better than life itself,
my lips will praise you. (Psalm 63:3)

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Rick Otten 2017-04-05 11:15:45 Re: Delete, foreign key, index usage
Previous Message Johann Spies 2017-04-04 12:07:06 Delete, foreign key, index usage