| From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
|---|---|
| To: | bricklen <bricklen(at)gmail(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: ALTER TABLE ... REPLACE WITH |
| Date: | 2010-12-17 07:05:05 |
| Message-ID: | 1292569505.1193.6949.camel@ebony |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, 2010-12-16 at 16:19 -0800, bricklen wrote:
> On Wed, Dec 15, 2010 at 2:39 AM, Simon Riggs <simon(at)2ndquadrant(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2010-12-17 07:46:56 | Re: Re: Proposed Windows-specific change: Enable crash dumps (like core files) |
| Previous Message | Craig Ringer | 2010-12-17 07:01:56 | Re: Re: Proposed Windows-specific change: Enable crash dumps (like core files) |