Skip site navigation (1) Skip section navigation (2)

Re: Updated ALTER TABLE ... SET TABLESPACE patch

From: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>
To: pgsql-patches(at)postgresql(dot)org
Subject: Re: Updated ALTER TABLE ... SET TABLESPACE patch
Date: 2004-06-30 21:29:18
Message-ID: Pine.LNX.4.58.0407010728030.23085@linuxworld.com.au (view raw or flat)
Thread:
Lists: pgsql-patches
On Thu, 1 Jul 2004, Gavin Sherry wrote:

> Hi all,
>
> Attached is an updated ALTER TABLE ... SET TABLESPACE patch.
>
> It uses the block by block copy mechanism proposed by Tom and handles i)
> ALTER TABLE <index> .... and ii) Copying of TOAST tables and the TOAST
> table's index.
>
> It doesn't handle copying of system tables (pg_largeobject) and, in the
> interests of code reuse, the patch fiddles with the code used by CLUSTER.
> This isn't great but I wanted to get a patch in before 1 July since I
> think the feature is very important -- even for the first release.

Oh, and it doesn't handle WAL. Tom mentioned/agreed that btree's method of
dumping whole pages into WAL would be the best/most efficient way to
journaling this and that the btree code should be generalised. I haven't
had time to look at this yet.

>
> Thanks,
>
> Gavin

In response to

Responses

pgsql-patches by date

Next:From: Simon RiggsDate: 2004-06-30 22:54:34
Subject: Re: PITR Archive Recovery
Previous:From: Andrew DunstanDate: 2004-06-30 20:19:07
Subject: latest plperl

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group