Postgres Pro
Downloads
Home   >   mailing lists

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

From DrakoRod
Subject The tables partitioning affects the indexes?
Date
Msg-id 1411680008162-5820572.post@n5.nabble.com
Whole thread Raw
Responses Re: The tables partitioning affects the indexes?  (Shreeyansh dba <shreeyansh2014@gmail.com>)
Re: The tables partitioning affects the indexes?  (jaime soler <jaime.soler@gmail.com>)
List pgsql-admin
Tree view 
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.

pgsql-admin by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Out of shared memory while creating a backup with pg_dump
Next
From: Shreeyansh dba
Date:
Subject: Re: The tables partitioning affects the indexes?