Re: Postgres and really huge tables

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-advocacy(at)postgresql(dot)org
Cc: Chris Mair <chris(at)1006(dot)org>, Brian Hurt <bhurt(at)janestcapital(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres and really huge tables
Date: 2007-01-20 00:04:12
Message-ID: 200701191604.13850.josh@agliodbs.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-performance


> A lot of data, but not a lot of records... I don't know if that's
> valid. I guess the people at Greenplum and/or Sun have more exciting
> stories ;)

Not really. Pretty much multi-terabyte tables are fine on vanilla
PostgreSQL if you can stick to partitioned and/or indexed access. If you
need to do unindexed fishing expeditions on 5tb of data, then talk to
Greenplum.

http://www.powerpostgresql.com/Downloads/terabytes_osc2005.pdf

--
--Josh

Josh Berkus
PostgreSQL @ Sun
San Francisco

In response to

Browse pgsql-advocacy by date

  From Date Subject
Next Message Robert Bernier 2007-01-20 16:22:56 Linuxworld Toronto, April 30 - May 2
Previous Message Brian Hurt 2007-01-19 17:32:05 Re: Postgres v MySQL 5.0

Browse pgsql-performance by date

  From Date Subject
Next Message Simon Riggs 2007-01-22 09:40:22 Re: Table Inheritence and Partioning
Previous Message Kevin Hunter 2007-01-19 21:40:55 Re: DB benchmark and pg config file help