Postgres Pro
Downloads
Home   >   mailing lists

Re: Indexes on inheriting tables - Mailing list pgsql-general

From Shoaib Mir
Subject Re: Indexes on inheriting tables
Date
Msg-id CABAdwW052oe3tLaLY+=SEBt=yvJyu2BV8Na5oujaB2qbhEw6vw@mail.gmail.com
Whole thread Raw
In response to Re: Indexes on inheriting tables  (Toby Corkindale <toby.corkindale@strategicdata.com.au>)
Responses Re: Indexes on inheriting tables
List pgsql-general
Tree view
On Thu, Aug 25, 2011 at 11:57 AM, Toby Corkindale <toby.corkindale@strategicdata.com.au> wrote:

It seems messy to inherit the columns but not the indexes or checks upon them :(



Yes it can be a bit annoying at timse but you can try to automate the whole process as well. Like I found this blog entry --> http://blog.inovia.fr/auto-partitioning-on-postgresql-part-1/

cheers,
Shoaib

pgsql-general by date:

Previous
From: Toby Corkindale
Date:
Subject: Re: Indexes on inheriting tables
Next
From: Royce Ausburn
Date:
Subject: Re: Collapsing multiple subqueries into one