Re: Dynamic Partitioning using Segment Visibility Maps - Mailing list pgsql-hackers

From Markus Schiltknecht
Subject Re: Dynamic Partitioning using Segment Visibility Maps
Date
Msg-id 477F9C96.1020309@bluegap.ch
Whole thread Raw
In response to Re: Dynamic Partitioning using Segment Visibility Maps  (tomas@tuxteam.de)
List pgsql-hackers
Hi,

tomas@tuxteam.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



pgsql-hackers by date:

Previous
From: jMartinez
Date:
Subject: pg 8.3 Windows installer suggestion
Next
From: Markus Schiltknecht
Date:
Subject: Re: Dynamic Partitioning using Segment Visibility Maps