From: apoc9009@yahoo.de <apoc9009@yahoo.de>
To: pgsql-performance@postgresql.org
Subject: Re: Table Partitioning: Will it be supported in Future?
Date: Tue, 26 Apr 2005 11:57:33 +0200
Message-ID: <426E108D.7000503@yahoo.de> (raw)
In-Reply-To: <426DFA43.5080801@archonet.com>
References: <426DF6C5.1090509@yahoo.de>
<426DFA43.5080801@archonet.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: apoc9009@yahoo.de
Subject: Re: Table Partitioning: Will it be supported in Future?
In-Reply-To: <426E108D.7000503@yahoo.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox