pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
The tables partitioning affects the indexes? 5+ messages / 3 participants [nested] [flat]
* The tables partitioning affects the indexes? @ 2014-09-25 21:20 DrakoRod <drakoflames@hotmail.com> 0 siblings, 2 replies; 5+ messages in thread From: DrakoRod @ 2014-09-25 21:20 UTC (permalink / raw) To: 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. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: The tables partitioning affects the indexes? @ 2014-09-26 17:40 Shreeyansh dba <shreeyansh2014@gmail.com> parent: DrakoRod <drakoflames@hotmail.com> 1 sibling, 1 reply; 5+ messages in thread From: Shreeyansh dba @ 2014-09-26 17:40 UTC (permalink / raw) To: DrakoRod <drakoflames@hotmail.com>; +Cc: pgsql-admin On Fri, Sep 26, 2014 at 2:50 AM, DrakoRod <drakoflames@hotmail.com> wrote: > 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! > I think there is no need of index on master table however master table does not contain any record in it. For better performance create index on child tables as they were on master table. Best Regards. Venkataramana Aitla www.shreeyansh.com > > > > -- > 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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin > ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: The tables partitioning affects the indexes? @ 2014-09-29 10:26 jaime soler <jaime.soler@gmail.com> parent: DrakoRod <drakoflames@hotmail.com> 1 sibling, 1 reply; 5+ messages in thread From: jaime soler @ 2014-09-29 10:26 UTC (permalink / raw) To: DrakoRod <drakoflames@hotmail.com>; +Cc: pgsql-admin 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: The tables partitioning affects the indexes? @ 2014-09-29 21:07 DrakoRod <drakoflames@hotmail.com> parent: Shreeyansh dba <shreeyansh2014@gmail.com> 0 siblings, 0 replies; 5+ messages in thread From: DrakoRod @ 2014-09-29 21:07 UTC (permalink / raw) To: pgsql-admin Ok! The master table many tuples, so the queries become very slow, we need partitioning it because the table is huge. Is for that my question. So we create indexes and permissions in the child tables! Thank you! ----- Dame un poco de fe, eso me bastará. Rozvo Ware Solutions -- View this message in context: http://postgresql.1045698.n5.nabble.com/The-tables-partitioning-affects-the-indexes-tp5820572p582101... Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: The tables partitioning affects the indexes? @ 2014-09-29 21:09 DrakoRod <drakoflames@hotmail.com> parent: jaime soler <jaime.soler@gmail.com> 0 siblings, 0 replies; 5+ messages in thread From: DrakoRod @ 2014-09-29 21:09 UTC (permalink / raw) To: pgsql-admin Perfect! Now understand! Thanks!! ----- Dame un poco de fe, eso me bastará. Rozvo Ware Solutions -- View this message in context: http://postgresql.1045698.n5.nabble.com/The-tables-partitioning-affects-the-indexes-tp5820572p582101... Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin ^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2014-09-29 21:09 UTC | newest] Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2014-09-25 21:20 The tables partitioning affects the indexes? DrakoRod <drakoflames@hotmail.com> 2014-09-26 17:40 ` Shreeyansh dba <shreeyansh2014@gmail.com> 2014-09-29 21:07 ` DrakoRod <drakoflames@hotmail.com> 2014-09-29 10:26 ` jaime soler <jaime.soler@gmail.com> 2014-09-29 21:09 ` DrakoRod <drakoflames@hotmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox