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

Re: Is there a way to SubPartition?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jerry Champlin <jchamplin(at)absolute-performance(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Is there a way to SubPartition?
Date: 2008-08-27 14:01:50
Message-ID: 22840.1219845710@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
Jerry Champlin <jchamplin(at)absolute-performance(dot)com> writes:
> Is there a way to use multi-level inheritance to achieve sub 
> partitioning that the query optimizer will recognize?

No, I don't think so.  How would that make things any better anyway?
You're still going to end up with the same very large number of
partitions.

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Matthew WakelingDate: 2008-08-27 14:10:28
Subject: Re: Is there a way to SubPartition?
Previous:From: Jerry ChamplinDate: 2008-08-27 13:45:49
Subject: Is there a way to SubPartition?

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