Postgres Pro
Downloads
Home   >   mailing lists

Re: The tables partitioning affects the indexes? - Mailing list pgsql-admin

From Shreeyansh dba
Subject Re: The tables partitioning affects the indexes?
Date
Msg-id CAGDYbUOALJYjO8a+b83QC5Pgot1A79koSF8hJY_wJPgo5ce0RQ@mail.gmail.com
Whole thread Raw
In response to The tables partitioning affects the indexes?  (DrakoRod <drakoflames@hotmail.com>)
Responses Re: The tables partitioning affects the indexes?  (DrakoRod <drakoflames@hotmail.com>)
List pgsql-admin
Tree view


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


pgsql-admin by date:

Previous
From: DrakoRod
Date:
Subject: The tables partitioning affects the indexes?
Next
From: jaime soler
Date:
Subject: Re: The tables partitioning affects the indexes?