Skip site navigation (1) Skip section navigation (2)

Re: Partitioning by status?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Partitioning by status?
Date: 2012-01-13 19:05:56
Message-ID: 4F108094.4070401@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-performance
On 1/13/12 2:44 AM, alexandre - aldeia digital wrote:
>>
>> Also, (2) only really works if you're going to obsolesce (remove)
>> archive records after a certain period of time.  Otherwise the
>> sub-partitioning hurts performance.
>>
> 
> Is there any moves to include the "easy" table partitioning in the 9.2
> version ?

Nobody has been submitting patches.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

In response to

Responses

pgsql-performance by date

Next:From: Josh BerkusDate: 2012-01-13 19:08:18
Subject: Re: Discovering the most searched values for a field
Previous:From: alexandre - aldeia digitalDate: 2012-01-13 18:08:59
Subject: Discovering the most searched values for a field

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group