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 trigger on the master table that sends the records to the appropriate child table instead. See this presentation from Robert Treat: http://www.slideshare.net/xzilla/postgresql-partitioning-pgcon-2007-presentation When that starts working, you can just slowly move records by doing an INSERT to the child tables and a DELETE from the master in the same transaction (probably in big batches). > Is there > any easy way to determine what records are in the master table and > which ones are in child tables? I can think of a few migration ideas > doing this. If you do "SELECT ONLY ..." it doesn't descend into the child tables. Regards, Jeff Davis -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
