>Easy first question: is the temp table analyzed before being used in a
> join ?
No, I haven't done that. Today, I tried to run
ANALYZE records_to_filter_on;
on the same sample data set (3.75 million rows) before the join, and it did not
seem to make much of a difference in terms
On Tue, Jul 27, 2021 at 09:08:49AM +, Simen Andreas Andreassen Lønsethagen
wrote:
> >Easy first question: is the temp table analyzed before being used in a
> > join ?
>
> No, I haven't done that. Today, I tried to run
>
> ANALYZE records_to_filter_on;
>
> on the same sample data
On Mon, Jul 26, 2021 at 01:56:54PM +, Simen Andreas Andreassen Lønsethagen
wrote:
> To create the subsets, I (or rather my application) will receive lists of
> records which should be matched according to some business logic. Each of
> these lists will be read into a temporary table:
Easy f
