Re: [pgsql-advocacy] Postgres and really huge tables - Mailing list pgsql-performance

From Josh Berkus
Subject Re: [pgsql-advocacy] Postgres and really huge tables
Date
Msg-id 200701191604.13850.josh@agliodbs.com
Whole thread Raw
In response to Re: [pgsql-advocacy] Postgres and really huge tables  (Chris Mair <chris@1006.org>)
List 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

pgsql-performance by date:

Previous
From: Kevin Hunter
Date:
Subject: Re: DB benchmark and pg config file help
Next
From: "Simon Riggs"
Date:
Subject: Re: Table Inheritence and Partioning