Postgres Pro
Downloads
Home   >   mailing lists

Re: Query Performance / Planner estimate off - Mailing list pgsql-performance

From Victor Yegorov
Subject Re: Query Performance / Planner estimate off
Date
Msg-id CAGnEbohHPxK4OzsgxV_KPVm+nTzN00DcrXXou0c96ENx7rau8Q@mail.gmail.com
Whole thread Raw
In response to Query Performance / Planner estimate off  (Mats Julian Olsen <mats@duneanalytics.com>)
Responses Re: Query Performance / Planner estimate off  (Mats Olsen <mats@duneanalytics.com>)
List pgsql-performance
Tree view
вт, 20 окт. 2020 г. в 11:38, Mats Julian Olsen <mats@duneanalytics.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

pgsql-performance by date:

Previous
From: Victor Yegorov
Date:
Subject: Re: Query Performance / Planner estimate off
Next
From: Sushant Pawar
Date:
Subject: Re: Query Performance / Planner estimate off