Re: Partitioning a table by integer value (preferably in place)

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: Vijaykumar Jain <vijaykumarjain(dot)github(at)gmail(dot)com>
Cc: Pól Ua Laoínecháin <linehanp(at)tcd(dot)ie>, PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Partitioning a table by integer value (preferably in place)
Date: 2021-08-13 15:37:22
Message-ID: CAHOFxGrL21QFSHSuY798br6GPjZbfhDtQL4wmUaZJfAYXoen_g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Aug 13, 2021 at 3:02 AM Vijaykumar Jain <
vijaykumarjain(dot)github(at)gmail(dot)com> wrote:

> ... use binary split for large partitions, to avoid large row movements.
>

Would you expound on this?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vijaykumar Jain 2021-08-13 15:50:06 Re: Join for the parent table will not leverage the index scan
Previous Message Adrian Klaver 2021-08-13 15:34:56 Re: Multiple Postgres process are running in background