Re: Query Performance / Planner estimate off

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Query Performance / Planner estimate off
From: Victor Yegorov <vyegorov@xxxxxxxxx>
Date: Tue, 20 Oct 2020 15:22:41 +0200
Cc: pgsql-performance@xxxxxxxxxxxxxx
In-reply-to: <CAARtqpGxzna+jj3LYNTacHxbC03-KdBs7XeQUaqwEkUJ+5QMbw@mail.gmail.com>
References: <CAARtqpGxzna+jj3LYNTacHxbC03-KdBs7XeQUaqwEkUJ+5QMbw@mail.gmail.com>

вт, 20 окт. 2020 г. в 11:38, Mats Julian Olsen <mats@xxxxxxxxxxxxxxxxx>:

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

Follow-Ups:
- Re: Query Performance / Planner estimate off
  - From: Mats Olsen

References:
- Query Performance / Planner estimate off
  - From: Mats Julian Olsen

Prev by Date: Re: Query Performance / Planner estimate off
Next by Date: Re: Query Performance / Planner estimate off
Previous by thread: Re: Query Performance / Planner estimate off
Next by thread: Re: Query Performance / Planner estimate off
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux