Re: ALTER TABLESPACE ... MOVE ALL TO ... - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: ALTER TABLESPACE ... MOVE ALL TO ...
Date
Msg-id 20140120160253.GL31026@tamriel.snowman.net
Whole thread Raw
In response to Re: ALTER TABLESPACE ... MOVE ALL TO ...  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
* Simon Riggs (simon@2ndQuadrant.com) wrote:
> > ALTER TABLESPACE name MOVE OWNED TO name opt_nowait
>
> The ALL seems to have value. "MOVE ALL OWNED TO" sounds better.

I could go either way on this, really.

> > ALTER TABLESPACE name MOVE TABLES OWNED TO name opt_nowait
> > ALTER TABLESPACE name MOVE INDEXES OWNED TO name opt_nowait
>
> On those two, I think the docs need to be clearer that we mean that
> TABLES means tables, and yes we leave the indexes behind. Or that
> INDEXES means "and we leave the tables behind. This is intended to
> more easily separate tables and indexes into their own tablespaces."
> or similar.

Sure, I can certainly improve the documentation on that.

> I'm not clamouring for squeezing additional goodies from you, just to
> make a small change to avoid later confusion (for ALL users ;-) )

:)  What are your thoughts on what I just proposed to Tom?

> Good feature, thanks for working on it.
Thanks!
    Stephen

pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: ALTER TABLESPACE ... MOVE ALL TO ...
Next
From: Antonin Houska
Date:
Subject: Re: Backup throttling