Postgres Pro
Downloads
Home   >   mailing lists

Must I create an index for child table if master table have one? - Mailing list pgsql-general

From Edmundo Robles
Subject Must I create an index for child table if master table have one?
Date
Msg-id CAOXzpYA+y-jLVku+TLfGdH62PJShmO0SXsf7Tc20tTGDoePLwA@mail.gmail.com
Whole thread Raw
Responses Re: Must I create an index for child table if master table have one?  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
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 ?

pgsql-general by date:

Previous
From: otar shavadze
Date:
Subject: Gin indexes on intarray is fast when value in array does not exists, and slow, when value exists
Next
From: "Joshua D. Drake"
Date:
Subject: Re: PHP-Shop with PostgreSQL