Re: Performance of lateral join
От | Justin Pryzby |
---|---|
Тема | Re: Performance of lateral join |
Дата | |
Msg-id | 20210726181745.GE23997@telsasoft.com обсуждение исходный текст |
Ответ на | Performance of lateral join (Simen Andreas Andreassen Lønsethagen <simen.lonsethagen@fremtind.no>) |
Ответы |
Re: Performance of lateral join
|
Список | pgsql-performance |
On Mon, Jul 26, 2021 at 01:56:54PM +0000, 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 tosome business logic. Each of these lists will be read into a temporary table: Easy first question: is the temp table analyzed before being used in a join ? (This is unrelated to "explain analyze"). > I am running PostgreSQL 11.9 on x86_64-pc-linux-gnu using AWS Aurora on a db.t3.large instance (https://aws.amazon.com/rds/instance-types/).The output of > FROM pg_settings > is attached in pg_settings.conf. I think the attachment is missing. -- Justin
В списке pgsql-performance по дате отправления: