Quick Links

Re: using sequential scan instead of index for join with a union

From:	Sergei Kornilov <sk(at)zsrv(dot)org>
To:	Kent Tong <kent(dot)tong(dot)mo(at)gmail(dot)com>, "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject:	Re: using sequential scan instead of index for join with a union
Date:	2019-05-17 09:23:19
Message-ID:	4370811558084999@myt4-c0b480c282c8.qloud-c.yandex.net
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-performance

Hi

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

regards, Sergei

In response to

using sequential scan instead of index for join with a union at 2019-05-17 09:15:19 from Kent Tong

Responses

Re: using sequential scan instead of index for join with a union at 2019-05-17 09:36:03 from Kent Tong

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Kent Tong	2019-05-17 09:36:03	Re: using sequential scan instead of index for join with a union
Previous Message	Kent Tong	2019-05-17 09:15:19	using sequential scan instead of index for join with a union