Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Sun, 30 Aug 2009 20:17:28 -0600
- Message-id: <200908302017.28383.kevink@consistentstate.com> <text/plain>
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.
- Follow-Ups:
- Re: indexes on partitioned tables - on the base table, or the partitioned tables?
- From: Hrishikesh Mehendale
- Re: indexes on partitioned tables - on the base table, or the partitioned tables?
- Prev by Date: Re: Query and the number of row result
- Next by Date: Re: Query and the number of row result
- Previous by thread: Query and the number of row result
- Next by thread: Re: indexes on partitioned tables - on the base table, or the partitioned tables?
- Indexes: