Re: partitioned table set and indexes

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: Rick Otten <rottenwindfish(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: partitioned table set and indexes
Date: 2015-12-12 03:13:38
Message-ID: 770682355.328334.1449890018990.JavaMail.open-xchange@oxweb01.ims-firmen.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> Rick Otten <rottenwindfish(at)gmail(dot)com> hat am 12. Dezember 2015 um 01:55
> geschrieben:
>
>
> Why does it index scan when I use where, but not when I do a join?

difficult to say/guess because of anonymized names and not knowing the real
query. This one? http://explain.depesz.com/s/1es ?
All seqscans are fast, a seqscan isn't evil per se.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff Janes 2015-12-12 16:58:51 Re: Advise needed for a join query with a where conditional
Previous Message Rick Otten 2015-12-12 00:55:14 Re: partitioned table set and indexes