Search Postgresql Archives

Re: need explanation about an explain plan

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

Subject: Re: need explanation about an explain plan
From: Laurenz Albe <laurenz.albe@xxxxxxxxxxx>
Date: Wed, 28 Jun 2023 22:46:14 +0200
Cc: "pgsql-general@xxxxxxxxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <CADX_1aZGvV1Ex=k122Zno5ZFbu7L9Y4cEajGSGMX_wZ8RCs62g@mail.gmail.com>
References: <CADX_1aZHUsDwXAutJ5Eh2d9dNnTjRoWV4f=tS0yBhQhLg5t+Hg@mail.gmail.com> <CADX_1aYVmbrbJi+62b06XWuLzn6CJs6P0K=wEDinJjcGvkuC+g@mail.gmail.com> <02665fc681ba77695ecf44bf1156e22ac09ae91e.camel@cybertec.at> <CADX_1aZGvV1Ex=k122Zno5ZFbu7L9Y4cEajGSGMX_wZ8RCs62g@mail.gmail.com>
User-agent: Evolution 3.46.4 (3.46.4-1.fc37)

On Wed, 2023-06-28 at 19:25 +0200, Marc Millas wrote:
> Hi Laurenz, as said, in each partition there is only one value for ladate.

The planner doesn't seem to take that into account.

Yours,
Laurenz Albe

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

Follow-Ups:
- Re: need explanation about an explain plan
  - From: Marc Millas

References:
- need explanation about an explain plan
  - From: Marc Millas
- Re: need explanation about an explain plan
  - From: Marc Millas
- Re: need explanation about an explain plan
  - From: Laurenz Albe
- Re: need explanation about an explain plan
  - From: Marc Millas

Prev by Date: Re: need explanation about an explain plan
Next by Date: recovery_target_action = shutdown not working on PG11 during PITR restore
Previous by thread: Re: need explanation about an explain plan
Next by thread: Re: need explanation about an explain plan
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux