How to move tables in another physial place

From: Michelle Konzack <linux4michelle(at)freenet(dot)de>
To: pgSQL - General <pgsql-general(at)postgresql(dot)org>
Subject: How to move tables in another physial place
Date: 2007-05-22 17:01:55
Message-ID: 20070522170155.GA1843@freenet.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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)

Greetings
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)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message PFC 2007-05-22 17:04:55 Re: Permance issues with migrated db
Previous Message Robert Fitzpatrick 2007-05-22 16:49:27 Re: Permance issues with migrated db