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

From Gregory Stark
Subject Re: Dynamic Partitioning using Segment Visibility Maps
Date
Msg-id 87abnh3w1f.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: Dynamic Partitioning using Segment Visibility Maps  (Andrew Sullivan <ajs@crankycanuck.ca>)
Responses Re: Dynamic Partitioning using Segment Visibility Maps  (Mark Kirkwood <markir@paradise.net.nz>)
Re: Dynamic Partitioning using Segment Visibility Maps  (Andrew Sullivan <ajs@crankycanuck.ca>)
Re: Dynamic Partitioning using Segment Visibility Maps  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
"Andrew Sullivan" <ajs@crankycanuck.ca> writes:

> On Mon, Jan 07, 2008 at 07:16:35PM +0100, Markus Schiltknecht wrote:
>> 
>> Does anything speak against letting the DBA handle partitions as relations?
>
> Yes: it doesn't solve the problem I have, which is that I don't want to have
> to manage a whole bunch of tables.  I want one table, and I want to be able
> to say, "That section is closed". 

That's not your problem, that's the solution you're looking for. You're
assuming a particular solution in your problem statement.

I posit that the whole point of partitioning is to create an object which
serves to represent the semantically meaningful chunks of data. The reason
this is useful is precisely because it serves as a short-hand for the DBA
describe the data and how it will be used.

I think Simon's proposal loses the very feature that makes partitioning
useful. The DBA doesn't have a "thing" to describe, he has to define what
parts of the table he's describing for every operation. And if you define a
whole new object to name these "things" I think you'll end up with something
that looks a lot like tables.

I also don't understand how this proposal deals with the more common use case
of unloading and loading data. Normally in partitioned tables we build the
data in a side table until the data is all correct then load it as a
partition. If you treat it as a lower-level object then I don't see that
working. The layout of the new table won't often match the layout of the
target partitioned table.


--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support!


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: 8.3.0 release schedule (Was:Re: [BUGS] BUG #3852: Could not create complex aggregate)
Next
From: Tom Lane
Date:
Subject: Re: ERROR: translation failed from server encoding to wchar_t