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

Re: Dynamic Partitioning using Segment Visibility Maps

From: Markus Schiltknecht <markus(at)bluegap(dot)ch>
To: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Dynamic Partitioning using Segment Visibility Maps
Date: 2008-01-05 10:13:12
Message-ID: 477F5838.7010904@bluegap.ch (view raw or flat)
Thread:
Lists: pgsql-hackers
Andrew Sullivan wrote:
> On Fri, Jan 04, 2008 at 10:26:54PM +0100, Markus Schiltknecht wrote:
>> I'm still puzzled about how a DBA is expected to figure out which 
>> segments to mark. 
> 
> I think that part might be hand-wavy still.  But once this facility is
> there, what's to prevent the current active segment (and the rest) from also
> getting this mark, which would mean "the table is read only"?  

Well, sure, marking *all* segments read-only is pretty easy. But that 
was not quite my point.

Regards

Markus


In response to

pgsql-hackers by date

Next:From: Jari AaltoDate: 2008-01-05 11:33:39
Subject: [PATCH] pg_hba.conf.sample: mention www.postgresql.org
Previous:From: Simon RiggsDate: 2008-01-05 09:33:45
Subject: Re: Dynamic Partitioning using Segment Visibility Maps

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