From: | "apoc9009(at)yahoo(dot)de" <apoc9009(at)yahoo(dot)de> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Table Partitioning: Will it be supported in Future? |
Date: | 2005-04-26 09:57:33 |
Message-ID: | 426E108D.7000503@yahoo.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hmm,
I have asked some Peoples on the List an some one has posted this links
http://archives.postgresql.org/pgsql-performance/2004-12/msg00101.php
It is quite usefull to read but iam not sure thadt theese Trick is verry
helpfull.
I want to splitt my 1GByte Table into some little Partitions but how
should i do thadt?
With the ORACLE Partitioning Option, i can Configurering my Table withe
Enterprise
Manager or SQL Plus but in this case it looks like Trap.
Should i really decrease my Tabledata size and spread them to other
Tables with the
same Structure by limiting Records???
The next Problem i see, how should i do a Insert/Update/Delete on 4
Tables of the
same Structure at one Query???
No missunderstanding. We talking not about normalization or
restructuring the Colums
of a table. We talking about Partitioning and in this case at Postgres
(emultation
of Partitioning wir UNIONS for Performance tuning)..
Josh
From | Date | Subject | |
---|---|---|---|
Next Message | Shoaib Burq (VPAC) | 2005-04-26 14:31:18 | Re: two queries and dual cpu (perplexed) |
Previous Message | apoc9009@yahoo.de | 2005-04-26 09:34:45 | Re: BLOB's bypassing the OS Filesystem for better Image |