Re: Query Performance / Planner estimate off

From: Victor Yegorov <vyegorov(at)gmail(dot)com>
To: Mats Julian Olsen <mats(at)duneanalytics(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Query Performance / Planner estimate off
Date: 2020-10-20 13:22:41
Message-ID: CAGnEbohHPxK4OzsgxV_KPVm+nTzN00DcrXXou0c96ENx7rau8Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

вт, 20 окт. 2020 г. в 11:38, Mats Julian Olsen <mats(at)duneanalytics(dot)com>:

> I'm looking for some help to manage queries against two large tables.
>

Also, can you enable `track_io_timing` (no restart required) and provide
output of `EXPLAIN (analyze, buffers, settings)` for all 3 variants,
please?
(I assume you're on 12+.)

--
Victor Yegorov

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Sushant Pawar 2020-10-20 13:40:08 Re: Query Performance / Planner estimate off
Previous Message Victor Yegorov 2020-10-20 13:04:56 Re: Query Performance / Planner estimate off