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

From Ron Johnson
Subject Re: How to move tables in another physial place
Date
Msg-id 46532C33.5080208@cox.net
Whole thread Raw
In response to How to move tables in another physial place  (Michelle Konzack <linux4michelle@freenet.de>)
Responses Re: How to move tables in another physial place
Re: How to move tables in another physial place
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 05/22/07 12:01, Michelle Konzack wrote:
> Hello,
>
> I am using Debian GNU/Linux 4.0 with postgresql 8.2.
>
> Now I have splited my Monster-Table of 580 GByte (historical timeline)
> into one table per year (= several 100 now) and use table partitioning.
> (Cool for pg_dump since I can dump singel tables and burn it now on CD
> or DVD). Then I have reorganized my server and now I have several Raid-1
> volumes to use table partitioning.
>
> The tables are now working and my Database is over 80 times faster
> because most searches are not over the whole table (580 GByte) but over
> a paticular time (mostly 20-40 years).
>
> What I want now is to move tables to another partition.
>
> How can I do this? (best and fastest way)

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.

- --
Ron Johnson, Jr.
Jefferson LA  USA

Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFGUywzS9HxQb37XmcRAlI4AKCHKBmWSW5FpLKmiPRvXfZqWd68RwCfaTOm
0qhxJymuK1WMXcQ9JcFfA1c=
=yTo5
-----END PGP SIGNATURE-----

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: swap storm created by 8.2.3
Next
From: "Ian Harding"
Date:
Subject: Re: short ciruit logic of plpgsql in 8.2