The tables partitioning affects the indexes?

From: DrakoRod <drakoflames(at)hotmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: The tables partitioning affects the indexes?
Date: 2014-09-25 21:20:08
Message-ID: 1411680008162-5820572.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi everybody!

I have a huge table that we need partitioning, partitioning rule is a
attribute date every 4 months.

My Master table have a many indexes. I need create indexes (with the same
indexes the master table) in the inherits tables? or this no affects
functionality of the indexes?

Best regards.

Thanks!

--
View this message in context: http://postgresql.1045698.n5.nabble.com/The-tables-partitioning-affects-the-indexes-tp5820572.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Shreeyansh dba 2014-09-26 17:40:56 Re: The tables partitioning affects the indexes?
Previous Message Kevin Grittner 2014-09-25 15:06:34 Re: Out of shared memory while creating a backup with pg_dump