Partitions and indexes - Mailing list pgsql-general

From Amitabh Kant
Subject Partitions and indexes
Date
Msg-id AANLkTimgXVgCjuFxTWME66SgrGaDOTQ12iE=3fdkwgvy@mail.gmail.com
Whole thread Raw
List pgsql-general
Hello

If I have partitioned a table based on a foreign key in a manner where every child table will only have data for single value of the foreign key, do I need to create a index for the foreign key in the primary and/or child tables? I am using version 8.4

With regards

Amitabh


pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: [GENERAL] FATAL: no pg_hba.conf entry for host “::1***"
Next
From: salah jubeh
Date:
Subject: Re: schema Cleanning