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

From Simon Riggs
Subject Re: ALTER TABLESPACE ... MOVE ALL TO ...
Date
Msg-id CA+U5nM+_WA64pyDT-FYc3DQvWuWewn3=Bgv10E5rMf+2srnyCQ@mail.gmail.com
Whole thread Raw
In response to ALTER TABLESPACE ... MOVE ALL TO ...  (Stephen Frost <sfrost@snowman.net>)
Responses Re: ALTER TABLESPACE ... MOVE ALL TO ...  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
On 16 January 2014 22:37, Stephen Frost <sfrost@snowman.net> wrote:

>   allow users to more easily move their various objects from
>   one tablespace to another.  Included are docs and a regression test;
>   I'm happy to improve on both should folks send me suggestions.

Sounds good.

The command uses the word ALL but then less than all objects, i.e.
only moves objects that are owned by the user.

I would like to see two variants of this...

ALL ... which attempts to move all objects and fails if it doesn't own
everything
ALL OWNED ... which moves only objects that it owns, and ignores others

i.e. ALL should mean all

-- Simon Riggs                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: Marti Raudsepp
Date:
Subject: Re: [Lsf-pc] Linux kernel impact on PostgreSQL performance
Next
From: Mel Gorman
Date:
Subject: Re: [Lsf-pc] Re: Linux kernel impact on PostgreSQL performance (summary v2 2014-1-17)