Home > mailing lists

Re: On partitioning, PKs and FKs - Mailing list pgsql-general

From	Wiwwo Staff
Subject	Re: On partitioning, PKs and FKs
Date	July 8, 2021 18:15:35
Msg-id	CAD1W9HUQqB4GTTmOUf9H7S-tN0kth1=aKb-h1qeq_Edpq-h5MA@mail.gmail.com Whole thread Raw
In response to	Re: On partitioning, PKs and FKs (Michael Lewis <mlewis@entrata.com>)
List	pgsql-general

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@entrata.com> wrote:

Why are you using hash partitioning?

From: Tom Lane
Date: 08 July 2021, 17:12:04
Subject: Re: Insert/Dump/Restore table with generated columns

From: Emiliano Saenz
Date: 08 July 2021, 20:28:52
Subject: Re: The Curious Case of the Table-Locking UPDATE Query