Re: [HACKERS] Proposal: Local indexes for partitioned table

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Jesper Pedersen <jesper(dot)pedersen(at)redhat(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, Maksim Milyutin <milyutinma(at)gmail(dot)com>
Subject: Re: [HACKERS] Proposal: Local indexes for partitioned table
Date: 2018-01-02 16:03:13
Message-ID: 20180102160313.aslhjfbecv65usvb@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Jesper Pedersen wrote:

> On 12/22/2017 10:10 AM, Alvaro Herrera wrote:

> > If you have wording suggestions for the doc changes, please send them
> > along.
>
> Maybe we should make the default index name more explicit under the 'name'
> parameter as attached.

I'm -0.2 on documenting this. In general, I'm hesitant to promise more
than strictly needed, mostly because it's more difficult to later change
our minds. For example, what if soon after this patch we decide to
invent a new mechanism for creating names on partitions? Also, in
reality there are additional considerations (how do we truncate very
long names, what do we do if the name is already taken) that I would
rather not ossify in user-facing documentation.

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jesper Pedersen 2018-01-02 16:09:19 Re: [HACKERS] Fix performance degradation of contended LWLock on NUMA
Previous Message Jesper Pedersen 2018-01-02 15:47:17 Re: [HACKERS] Proposal: Local indexes for partitioned table