Re: How to move tables in another physial place

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)


You are looking for tablespaces.

http://www.postgresql.org/docs/8.0/interactive/manage-ag-tablespaces.html

>
> Greetings
>     Michelle Konzack
>     Systemadministrator
>     Tamay Dogan Network
>     Debian GNU/Linux Consultant
>
>


--

       === 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/