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

From Richard Huxton
Subject Re: Dynamic Partitioning using Segment Visibility Maps
Date
Msg-id 477E08F0.7080308@archonet.com
Whole thread Raw
In response to Dynamic Partitioning using Segment Visibility Maps  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Dynamic Partitioning using Segment Visibility Maps  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
Simon Riggs wrote:
> We would keep a dynamic visibility map at *segment* level, showing which
> segments have all rows as 100% visible. No freespace map data would be
> held at this level. 

Small dumb-user question.

I take it you've considered some more flexible consecutive-run-of-blocks 
unit of flagging rather than file-segments. That obviously complicates 
the tracking but means you can cope with infrequent updates as well as 
mark most of the "most recent" segment for log-style tables.

--   Richard Huxton  Archonet Ltd


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Dynamic Partitioning using Segment Visibility Maps
Next
From: Simon Riggs
Date:
Subject: Re: Dynamic Partitioning using Segment Visibility Maps