Postgres Pro
Downloads
Home   >   mailing lists

Re: What needs to be done for real Partitioning? - Mailing list pgsql-performance

From PFC
Subject Re: What needs to be done for real Partitioning?
Date
Msg-id op.snxln9r7th1vuj@localhost
Whole thread Raw
In response to Re: What needs to be done for real Partitioning?  (Greg Stark <gsstark@mit.edu>)
List pgsql-performance
Tree view 

> 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.

pgsql-performance by date:

Previous
From: Greg Stark
Date:
Subject: Re: What needs to be done for real Partitioning?
Next
From: Tom Lane
Date:
Subject: Re: What needs to be done for real Partitioning?