Re: What needs to be done for real Partitioning?

From: PFC <lists(at)boutiquenumerique(dot)com>
To: "Greg Stark" <gsstark(at)mit(dot)edu>, "Josh Berkus" <josh(at)agliodbs(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: What needs to be done for real Partitioning?
Date: 2005-03-20 10:20:23
Message-ID: op.snxln9r7th1vuj@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> It would also be reasonable to allow clustering individual partitions;
> creating table or column constraints on some partitions and not others;

I have a session mamagement which works like that, using views now.

sessions.online is a table of the online sessions. It has a UNIQUE on
user_id.
sessions.archive contains all the closed sessions. Obviously it does not
have a UNIQUE on user_id.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-03-20 17:58:30 Re: What needs to be done for real Partitioning?
Previous Message Greg Stark 2005-03-20 06:14:01 Re: What needs to be done for real Partitioning?