Re: Planner performance in partitions
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: Re: Planner performance in partitions
From
: Michael Lewis <mlewis@xxxxxxxxxxx>
Date
: Mon, 12 Aug 2019 16:37:26 -0600
Cc
: Piotr Włodarczyk <piotrwlodarczyk89@xxxxxxxxx>, MichaelDBA <MichaelDBA@xxxxxxxxxxx>, Piotr Włodarczyk <piotr.wlodarczyk@xxxxxx>, "pgsql-performance@xxxxxxxxxxxxxxxxxxxx" <pgsql-performance@xxxxxxxxxxxxxxxxxxxx>
In-reply-to
: <CAKJS1f9DEHYHu=hJPE_SYj9eheWK4F8iPNQGBApT4AHKgxVywQ@mail.gmail.com>
References
: <
5675f9f771f04d9f8b5cffe16f4a4175@EX13MBX02.gb.ad.corp
> <
CAHOFxGrPiuFFNETAbV3rcw1COns8vJbgPm5zrGiSeO9GZPRshQ@mail.gmail.com
> <
458dfc43-b097-29f3-4e0e-857b9c30b427@sqlexec.com
> <
5d51c622.1c69fb81.4032d.34d9@mx.google.com
> <CAKJS1f9DEHYHu=hJPE_SYj9eheWK4F8iPNQGBApT4AHKgxVywQ@mail.gmail.com>
Was there a reason to exceed 100-500 partitions in real life that pushed you to do this test? Is there some issue you see when using 100 partitions that is solved or reduced in severity by increasing to 1200 or 6000 partitions?
Follow-Ups
:
ODP: Planner performance in partitions
From:
Piotr Włodarczyk
References
:
Planner performance in partitions
From:
Piotr Włodarczyk
Re: Planner performance in partitions
From:
Michael Lewis
Re: Planner performance in partitions
From:
MichaelDBA
ODP: Planner performance in partitions
From:
Piotr Włodarczyk
Re: Planner performance in partitions
From:
David Rowley
Prev by Date:
Re: Last event per user
Next by Date:
Re:
Previous by thread:
Re: Planner performance in partitions
Next by thread:
ODP: Planner performance in partitions
Index(es):
Date
Thread
[Postgresql General]
[Postgresql PHP]
[PHP Users]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Yosemite]