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

From: Edmundo Robles <edmundo(at)sw-argos(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Must I create an index for child table if master table have one?
Date: 2016-11-08 18:08:27
Message-ID: CAOXzpYA+y-jLVku+TLfGdH62PJShmO0SXsf7Tc20tTGDoePLwA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2016-11-08 18:24:04 Re: PHP-Shop with PostgreSQL
Previous Message otar shavadze 2016-11-08 17:43:19 Gin indexes on intarray is fast when value in array does not exists, and slow, when value exists