El jue, 25-09-2014 a las 14:20 -0700, DrakoRod escribió: > 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! Reference: http://www.postgresql.org/docs/9.3/static/tutorial-inheritance.html "Note: Although inheritance is frequently useful, it has not been integrated with unique constraints or foreign keys, which limits its usefulness. See Section 5.8 for more detail." I think, you should create index in the child tables. > > > > -- > 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. > > -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
