indexes on partitioned tables - on the base table, or the partitioned tables?

From: Kevin Kempter <kevink(at)consistentstate(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: indexes on partitioned tables - on the base table, or the partitioned tables?
Date: 2009-08-31 02:17:28
Message-ID: 200908302017.28383.kevink@consistentstate.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all;

where's the best place for the indexes/constraints on a partitioned table.

I assume it's best to place the FK constraints/triggers on the base/master
table and the indexes on the individual partition tables.

Thoughts?

Thanks in advance.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message bilal ghayyad 2009-08-31 02:35:42 Re: Query and the number of row result
Previous Message David Fetter 2009-08-31 02:12:39 Re: Query and the number of row result