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/
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
