Re: How to move tables in another physial place

Ron Johnson wrote:
> -----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.
>

Hard drive partitions.

Joshua D. Drake

> - --
> 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-----
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/