On Thu, 2010-12-16 at 16:19 -0800, bricklen wrote: > On Wed, Dec 15, 2010 at 2:39 AM, Simon Riggs <si...@2ndquadrant.com> wrote: > > Perhaps a more useful definition would be > > > > EXCHANGE TABLE target WITH source; > > > > which just swaps the heap and indexes of each table. > > At the risk of stating the obvious, this would work with partition exchange > too?
Yes, that is one use case. -- Simon Riggs http://www.2ndQuadrant.com/books/ PostgreSQL Development, 24x7 Support, Training and Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers