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

From Gokulakannan Somasundaram
Subject Re: Dynamic Partitioning using Segment Visibility Maps
Date
Msg-id 9362e74e0801032336u23f2453hfc97ffb4ac623021@mail.gmail.com
Whole thread Raw
In response to Re: 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
Hi Simon,<br />             Looks like a novel idea. I just want to confirm my understanding of the proposal.<br />a)
Thisproposal would work for the kind of table organizations which are currently partitioned and maintained based on
somekind of timestamp. Consider one of the use-case. A large Retail firm has a lot of stores. DBA maintains and updates
theinventories of those stores in hash-partitions based on store-no. As the inventory gets updated, the corresponding
partitionreceives the update and it goes like that.. <br />        Here all the partitions are going to get constantly
updated.So no partition can possibly become a read only partition. You have clearly called it out in your para. i am
justre-confirming on that. Or do you have something for this in your soln.? <br /><br />To my limited experience, most
partitionstrategies are based on some form of time-stamp. If the proposed soln. can cater to those, it has lot of
use-cases.<br/><br />Thanks,<br />Gokul.<br /><br /> 

pgsql-hackers by date:

Previous
From: "Warren Turkal"
Date:
Subject: Re: timestamp typedefs
Next
From: Fujii Masao
Date:
Subject: Re: Archiver behavior at shutdown