Re: [GENERAL] Table inheritance and partitioning

2009-05-27 Thread Jeff Davis
On Wed, 2009-05-27 at 15:52 -0500, Kevin Barnard wrote: > I am making the move to partition a table. I am trying to figure out > the best way to migrate data to the partitions. I would prefer to not > have down time. Does anybody have advice to give on this? One strategy is to create a trig

Re: [GENERAL] Table inheritance and partitioning

2009-05-27 Thread Vick Khera
On Wed, May 27, 2009 at 4:52 PM, Kevin Barnard wrote: > I am making the move to partition a table.  I am trying to figure out the > best way to migrate data to the partitions.  I would prefer to not have down > time.  Does anybody have advice to give on this?  Is there any easy way to > determine

[GENERAL] Table inheritance and partitioning

2009-05-27 Thread Kevin Barnard
I am making the move to partition a table. I am trying to figure out the best way to migrate data to the partitions. I would prefer to not have down time. Does anybody have advice to give on this? Is there any easy way to determine what records are in the master table and which ones are