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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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