Postgres Pro
Downloads
Home   >   mailing lists

Re: using sequential scan instead of index for join with a union - Mailing list pgsql-performance

From Sergei Kornilov
Subject Re: using sequential scan instead of index for join with a union
Date
Msg-id 4370811558084999@myt4-c0b480c282c8.qloud-c.yandex.net
Whole thread Raw
In response to using sequential scan instead of index for join with a union  (Kent Tong <kent.tong.mo@gmail.com>)
Responses Re: using sequential scan instead of index for join with a union  (Kent Tong <kent.tong.mo@gmail.com>)
List pgsql-performance
Tree view 
Hi

Please check datatypes in union all part. Possible, notice.id or notice.mbct_id datatypes does not match with other
tables.

regards, Sergei

pgsql-performance by date:

Previous
From: Kent Tong
Date:
Subject: using sequential scan instead of index for join with a union
Next
From: Kent Tong
Date:
Subject: Re: using sequential scan instead of index for join with a union