>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
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
Hi, first time posting, hope I have included the relevant information.
I am trying to understand the performance of a query which is intended to
retrieve a subset of the following table:
Table "contracts.bis_person_alle_endringer"
Column |