Re: Must I create an index for child table if master table have one?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Edmundo Robles <edmundo(at)sw-argos(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Must I create an index for child table if master table have one?
Date: 2016-11-08 18:33:02
Message-ID: CAKFQuwaMgxosLfNsTgMBk5PRJhT=+uabdpLs7hOBOOgyfFEdCw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Nov 8, 2016 at 11:08 AM, Edmundo Robles <edmundo(at)sw-argos(dot)com>
wrote:

> Hi!
>
> i have a simple question, if the master table have an index, must i
> have create the same index in a child table?
> what is the best practice for indexes in table partition ?
>

Indexes are self-contained within the physical table on which they are
defined. The index on the master contains no rows that are present in the
child table.

David J.​

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Melvin Davidson 2016-11-08 18:46:48 Re: Must I create an index for child table if master table have one?
Previous Message Joshua D. Drake 2016-11-08 18:24:04 Re: PHP-Shop with PostgreSQL