Future of Table Partitioning

From: "Patrick Carriere" <patrick(dot)carriere(at)nexustelecom(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Future of Table Partitioning
Date: 2006-02-16 17:03:17
Message-ID: A0DDA6A336884346B764323F595452050FC74A@nosferatu.nexus-ag.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

I was wondering what the plan is for the future of table partitioning in
PostgresQL. It is pretty hard for me to implement partitioning right now
with its current limitation, specifically the fact that unique
constraints cannot be enforced across partitions and that Constraint
Exclusion cannot be used on non-constant values like CURRENT_DATE. It is
also quite cumbersome to do all the maintenance work to create the new
child table, do the triggers, drop the old one, etc,etc using the table
inheritance every week since I would need to do weekly and monthly table
partitioning.

So, my question in short, Is there any plan to at least do Global unique
check constraints (or at least a global unique index) and is there a
thread/documentation somewhere about what are the future planned changes
to table partitioning?

Thanks

Patrick Carriere
Software Architect
Nexus Telecom (Americas)

Browse pgsql-performance by date

  From Date Subject
Next Message Adam Alkins 2006-02-16 17:03:29 Index Choice Problem
Previous Message Martijn van Oosterhout 2006-02-16 16:59:59 Re: qsort again (was Re: [PERFORM] Strange Create