From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Michelle Konzack <linux4michelle(at)freenet(dot)de> |
Cc: | pgSQL - General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: How to move tables in another physial place |
Date: | 2007-05-22 17:41:12 |
Message-ID: | 46532B38.6090102@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Johnson | 2007-05-22 17:45:23 | Re: How to move tables in another physial place |
Previous Message | Ron Johnson | 2007-05-22 17:40:50 | Re: swap storm created by 8.2.3 |