From: | Shreeyansh dba <shreeyansh2014(at)gmail(dot)com> |
---|---|
To: | DrakoRod <drakoflames(at)hotmail(dot)com> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: The tables partitioning affects the indexes? |
Date: | 2014-09-26 17:40:56 |
Message-ID: | CAGDYbUOALJYjO8a+b83QC5Pgot1A79koSF8hJY_wJPgo5ce0RQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Fri, Sep 26, 2014 at 2:50 AM, DrakoRod <drakoflames(at)hotmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
From | Date | Subject | |
---|---|---|---|
Next Message | jaime soler | 2014-09-29 10:26:12 | Re: The tables partitioning affects the indexes? |
Previous Message | DrakoRod | 2014-09-25 21:20:08 | The tables partitioning affects the indexes? |