| From: | Oleksandr Voytsekhovskyy <young(dot)inbox(at)gmail(dot)com> |
|---|---|
| To: | Michael Lewis <mlewis(at)entrata(dot)com> |
| Cc: | Ron <ronljohnsonjr(at)gmail(dot)com>, PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Simple IN vs IN values performace |
| Date: | 2021-02-23 09:30:56 |
| Message-ID: | A5F5CB0B-DE62-49A2-BD5D-E39F26C34F87@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Greetings,
Didn’t get your ideas with materialized CTE or a subquery with OFFSET 0
Could you please show simple example?
> 23 февр. 2021 г., в 04:33, Michael Lewis <mlewis(at)entrata(dot)com> написал(а):
>
> Insert the values into a TEMPORARY TABLE, then join that to your main table?
>
> In my experience, this is very performant but needs an analyze command after populating the temp table to ensure there are statistics so the plan doesn't go awry. Otherwise, I'm not sure it is different from a materialized CTE or a subquery with OFFSET 0 at the end.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander Voytsekhovskyy | 2021-02-23 09:35:42 | Re: Simple IN vs IN values performace |
| Previous Message | Adrian Klaver | 2021-02-23 05:23:02 | Re: pg_restore - generated column - not populating |