Search Postgresql Archives

Re: On partitioning, PKs and FKs

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

Subject: Re: On partitioning, PKs and FKs
From: Wiwwo Staff <wiwwo@xxxxxxxxx>
Date: Thu, 8 Jul 2021 17:15:35 +0200
In-reply-to: <CAHOFxGphYRztw9cq5Sf5-W0mnGqtRXXB+sm-2=xxE=n3djvjDQ@mail.gmail.com>
References: <CAD1W9HW+u8uouPfV9=UED4-TyXGL_3ffbhMU53iPUUGkpg9ETA@mail.gmail.com> <CAHOFxGphYRztw9cq5Sf5-W0mnGqtRXXB+sm-2=xxE=n3djvjDQ@mail.gmail.com>

Big big variability on partitioned column, which is filtered (where condition) in (almost) all queries.

On Thu, 8 Jul 2021 at 14:23, Michael Lewis <mlewis@xxxxxxxxxxx> wrote:

Why are you using hash partitioning?

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

References:
- On partitioning, PKs and FKs
  - From: Wiwwo Staff
- Re: On partitioning, PKs and FKs
  - From: Michael Lewis

Prev by Date: Re: Insert/Dump/Restore table with generated columns
Next by Date: Re: The Curious Case of the Table-Locking UPDATE Query
Previous by thread: Re: On partitioning, PKs and FKs
Next by thread: optimization issue
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