Clustering/Partitioning tables from existing tables?

From: Michelle Konzack <linux4michelle(at)freenet(dot)de>
To: pgSQL - General <pgsql-general(at)postgresql(dot)org>
Subject: Clustering/Partitioning tables from existing tables?
Date: 2008-01-26 12:06:33
Message-ID: 20080126120633.GW696@freenet.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

Last night I was working realy hard (10 hours) while reinstalling some
servers in Freiburg and now I have a big problem/question to tables...

My customer had used PostgreSQL 7.4 and we have dumped all tables into
separated dumps because the tables are toooooo big!!!

Formerly, it was the software accessing the Database which handled the
searches in the over 8000 tables which have between 50 and 2000 MByte
each!

We have now installed PostgreSQL 8.2 and imported all tables but since
this tables are generaly ONE table, I like to make a partitioned table
from it.

Q 1: How to create the "master" table now?

Q 2: Can anyone provide me a script whic do that.
(I am NOT THE GENIE)

Note: The tables have only names like "data_NNNNN" where NNNNN
is a number from 00000 (yes, with leading zeros) to 99999.

Thanks, Greetings and nice Day
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)

Browse pgsql-general by date

  From Date Subject
Next Message Louis-David Mitterrand 2008-01-26 16:47:02 Re: can't create index with 'dowcast' row
Previous Message Scott Marlowe 2008-01-26 02:46:24 Re: match accented chars with ASCII-normalised version