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

Re: Dynamic Partitioning using Segment Visibility Maps

From: Markus Schiltknecht <markus(at)bluegap(dot)ch>
To: tomas(at)tuxteam(dot)de
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, pgsql-hackers(at)postgresql(dot)org, Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
Subject: Re: Dynamic Partitioning using Segment Visibility Maps
Date: 2008-01-05 15:04:54
Message-ID: 477F9C96.1020309@bluegap.ch (view raw or flat)
Thread:
Lists: pgsql-hackers
Hi,

tomas(at)tuxteam(dot)de wrote:
>> The main proposal deliberately has few, if any, knobs and dials. That's
>> a point of philosophy that I've had views on previously: my normal
>> stance is that we need some knobs to allow the database to be tuned to
>> individual circumstances. 
> 
> One thought I had back then, with partitioned tables was "gee -- B-tree
> index is already doing a partition; why do a manual partition on top of
> that?".

Well, that's why I'm so focused on manageability: I think the primary 
purpose of partitioning is manageability (of the underlying storage for 
a table).

Regards

Markus


In response to

pgsql-hackers by date

Next:From: Markus SchiltknechtDate: 2008-01-05 15:42:28
Subject: Re: Dynamic Partitioning using Segment Visibility Maps
Previous:From: jMartinezDate: 2008-01-05 13:56:57
Subject: pg 8.3 Windows installer suggestion

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