[ANNOUNCE] Let's Party! (table partitioner) 0.1 released

From: "Leonardo Francalanci" <lfrancalanci(at)simtel(dot)ie>
To: "postgresql" <pgsql-general(at)postgresql(dot)org>
Subject: [ANNOUNCE] Let's Party! (table partitioner) 0.1 released
Date: 2004-09-14 08:24:42
Message-ID: KNEFJLENOMMIGOKNCBFAAEMAEOAA.lfrancalanci@simtel.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Let's Party! provides any database with table partitioning capabilities
(as long as it is accessed using JDBC).

In case you think this could be of any interest if integrated
in Postgresql (I mean if it was a core functionality of Postgresql,
not just a JDBC driver) let me know.

Why table partitioning?
Because:

1. If you put your partitions on different hard disks you will gain
throughput
2. Scans of tables will require less time, because you will access less
data -> a little table scan can be much faster than an access by index on a
big table
3. You can put partitions you use less often on slower hard disks or on the
network
4. You can put partitions on different clusters, for example using C-JDBC
(beware: selecting from more than one partition from different clusters
will not work because C-JDBC can't do unions between two clusters)
5. On future versions there will be the option to remove a column (part of
an index)
if this has low cardinality and replace it with different partitions

Please have a look (http://letsparty.sourceforge.net/)
and contact me using the forum
(http://sourceforge.net/forum/forum.php?forum_id=382504)
in case you need any help.

Leonardo

Browse pgsql-general by date

  From Date Subject
Next Message Gaetano Mendola 2004-09-14 08:52:04 Re: postgresql hanging (blocking) with smp kernel
Previous Message Richard Huxton 2004-09-14 08:23:43 Re: Best practices for migrating a development database