Re: partitioned table set and indexes - Mailing list pgsql-performance

From Andreas Kretschmer
Subject Re: partitioned table set and indexes
Date
Msg-id 770682355.328334.1449890018990.JavaMail.open-xchange@oxweb01.ims-firmen.de
Whole thread Raw
In response to Re: partitioned table set and indexes  (Rick Otten <rottenwindfish@gmail.com>)
List pgsql-performance

> Rick Otten <rottenwindfish@gmail.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.


pgsql-performance by date:

Previous
From: Rick Otten
Date:
Subject: Re: partitioned table set and indexes
Next
From: Jeff Janes
Date:
Subject: Re: Advise needed for a join query with a where conditional