Re: How to move tables in another physial place - Mailing list pgsql-general

Am 2007-05-22 12:45:23, schrieb Ron Johnson:
> Your subject says "physial place", but then you ask about moving a
> table to another partition.
>
> Since partitions are sub-sections of tables, I don't understand what
> you are asking.

:-)

INSIDE the postgresql I use table partitioning but the whole database
is on ONE PHYSICAL partition (/dev/sdb1) in the moment.

I know tablespace and want to move parts of the Maintable (which is
cutted down in many smaler parts) on another PYSIACAL partitonon of
/dev/sdc1, /dev/sdd1 and /dev/sde1 to reduce the seeks on the drives.

But since the database IS on ONE PYSIACAL partiton I do not know,
HOW TO MOVE some of the smaller tables (without stoping the PostgreSQL
from operating since it is needed 24/7)

Thanks, Greetings and nice Day
    Michelle Konzack
    Systemadministrator
    Tamay Dogan Network
    Debian GNU/Linux Consultant


--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack   Apt. 917                  ICQ #328449886
                   50, rue de Soultz         MSN LinuxMichi
0033/6/61925193    67100 Strasbourg/France   IRC #Debian (irc.icq.com)