From: | Michelle Konzack <linux4michelle(at)freenet(dot)de> |
---|---|
To: | pgSQL - General <pgsql-general(at)postgresql(dot)org> |
Subject: | Quering 4 or more physicale different PostgreSQL server at once |
Date: | 2007-02-21 16:47:25 |
Message-ID: | 20070221164725.GH1907@freenet.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
My current PostgreSQL Database has arround 560 GByte without indices.
If not more then 3-5 user query it it works fast like Google... :-)
But I have over 600 Users now which all query it over the Net and hit
a heavy performance problem.
The biggest problem is the "main" table which is arround 80% of the DB.
Now I have made a statistic and know, which Datas are most quried and
like to split the Database (exactly THE MONSTER-TABLE) over at least 4
Physicaly PostgreSQL servers.
The Database is generaly STATIC an Data will only be added and NEVER
removed or changed. (If DATE or a ROW change, it will get a FULL NEW
ROW with version number)
Since I access the PostgreSQL from a pysicaly seperated dedicated
apache server using php5 I like to know from some Experts how to
query 4 or more Databases ar once and join the data.
I thinking, putting the main database with most requested data on the
first Server which will have arround 180 GByte and then the rest of
"THE" table on the other servers.
Note: "THE" table is a historical timeline...
and the datasets are not ordered in the table.
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 MSM LinuxMichi
0033/6/61925193 67100 Strasbourg/France IRC #Debian (irc.icq.com)
From | Date | Subject | |
---|---|---|---|
Next Message | Michelle Konzack | 2007-02-21 16:47:32 | Re: Any Plans for cross database queries on the same server? |
Previous Message | Lincoln Yeoh | 2007-02-21 16:46:26 | Re: postgresql vs mysql |