Re: Indexes on inheriting tables

From: Shoaib Mir <shoaibmir(at)gmail(dot)com>
To: Toby Corkindale <toby(dot)corkindale(at)strategicdata(dot)com(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Indexes on inheriting tables
Date: 2011-08-25 02:10:36
Message-ID: CABAdwW052oe3tLaLY+=SEBt=yvJyu2BV8Na5oujaB2qbhEw6vw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Aug 25, 2011 at 11:57 AM, Toby Corkindale <
toby(dot)corkindale(at)strategicdata(dot)com(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Royce Ausburn 2011-08-25 02:19:15 Re: Collapsing multiple subqueries into one
Previous Message Toby Corkindale 2011-08-25 01:57:03 Re: Indexes on inheriting tables