Scott Marlowe wrote:
On Wed, 2005-03-09 at 10:31, FERREIRA William (COFRAMI) wrote:
hi
does the table partitionning exists under PostgreSQL ? or maybe an alternative exists ?
Oracle implements this system : it allows to spread rows on differents
partitions depending on an attribute.
For example, my application store xml documents in database, an the
partitionning is used to spread the differents documents on differents
partitions.
Currently, doing this in PostgreSQL is more of a "roll your own" thing. you create the base tables on different table spaces, then create an
updatable view with the proper triggers to make sure that the incoming
records go to the right tables.
With the advent of very large raid arrays with very fast caching
controllers, this methodology is becoming less and less necessary.
I don't agree with this. There are many postgresql users who have 100, 200, 600 GB databases that don't have the budget to purchase a 20,000 array.
Table partitioning is a way to keep things efficient. That should be regardless of technology.
RAM is cheap, so lets just use as much of it as we can even if it means we swap.
Sincerely,
Joshua D. Drake
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
-- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - jd@xxxxxxxxxxxxxxxxx - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL
begin:vcard fn:Joshua Drake n:Drake;Joshua org:Command Prompt, Inc. adr:;;PO Box 215 ;Cascade Locks;OR;97014;US email;internet:jd@xxxxxxxxxxxxxxxxx title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 x-mozilla-html:FALSE url:http://www.commandprompt.com version:2.1 end:vcard
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
