[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: [PERFORM] partitioned table set and indexes
From:       Andreas Kretschmer <andreas () a-kretschmer ! de>
Date:       2015-12-12 3:13:38
Message-ID: 770682355.328334.1449890018990.JavaMail.open-xchange () oxweb01 ! ims-firmen ! de
[Download RAW message or body]



> 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.


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
[prev in list] [next in list] [prev in thread] [next in thread]