Re: partitionning - Mailing list pgsql-general

From Scott Marlowe
Subject Re: partitionning
Date
Msg-id 1110396510.19624.51.camel@state.g2switchworks.com
Whole thread Raw
In response to Re: partitionning  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: partitionning
List pgsql-general
On Wed, 2005-03-09 at 13:21, Joshua D. Drake wrote:
> 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.

A Good AMI Megaraid card with 512 meg of battery backed cache will work
the same here.  I.e. eliminate the need for partitioning.  it doesn't
have to cost $20,000 to do it.  And let's never forget that the data is
where the value is, not the hardware.   Notice I wasn't saying there was
never a need anyway, just that it's becoming less of an issue each day.
which it is. Back in the day a decent one scsi interface RAID card with
battery backed cache was >$2,000.  nowadays, they've dropped to the $300
to $500 range.  I can't see the cost of a DBA figuring out and
implementing partitioning schemes costing less than that in time.  Plus
it puts your data on a more reliable system.  Penny wise and pound
foolish to go cheap in my opinion.

Anyone keeping 600 gigs of data and trying to save $500 in hardware
costs is saving costs in the wrong places, imnsho...

> Table partitioning is a way to keep things efficient. That
> should be regardless of technology.

Yes, it is a way.  It's just a less necessary one than it once was, with
hardware now able to provide the same performance increase with little
or no work on the users part.  We've got to weigh the increased
complexity it would take to implement it in Postgresql and maintain it
versus the gain, and I say the gain is smaller every day.

> RAM is cheap, so lets just use as much of it as we can even
> if it means we swap.

What does table partitioning have to do with RAM?

pgsql-general by date:

Previous
From: marcelo Cortez
Date:
Subject: Re: segmentation fault
Next
From: Lonni J Friedman
Date:
Subject: Re: segmentation fault