Horton

Re: What needs to be done for real Partitioning?

PFC <lists@boutiquenumerique.com>

View thread
From: PFC <lists@boutiquenumerique.com>
To: "Greg Stark" <gsstark@mit.edu>, "Josh Berkus" <josh@agliodbs.com>
Cc: pgsql-performance@postgresql.org
Date: 2005-03-20T10:20:23Z
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.