Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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)

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group