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: Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>, 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-04 13:04:59
Message-ID: 20180104130459.phzv4sovrnlu57yx@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers


Jesper Pedersen wrote:
> indexing.sql contains a \di command which list the owner of the db, so make
> check-world fails.

Wow, that was a stupid oversight, thanks for pointing it out. Here's a
version that applies to today's master, and fixes this problem.

No other changes.

(I didn't incorporate your proposal to document the index naming
pattern. I propose that you post it in its own thread, so that it can
be discussed on its own merits. Note typo "formular" in your patch; I'd
suggest "pattern" or some such rather than "formula" though.)

Álvaro Herrera
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Attachment Content-Type Size
v10-0001-Local-partitioned-indexes.patch text/plain 152.4 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2018-01-04 13:05:25 Re: Enhance pg_stat_wal_receiver view to display connected host
Previous Message Robert Haas 2018-01-04 12:59:08 Re: Observations in Parallel Append