From: Josh Berkus <josh@agliodbs.com>
To: pgsql-advocacy@postgresql.org
Cc: Chris Mair <chris@1006.org>
Cc: Brian Hurt <bhurt@janestcapital.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgres and really huge tables
Date: Fri, 19 Jan 2007 16:04:12 -0800
Message-ID: <200701191604.13850.josh@agliodbs.com> (raw)
In-Reply-To: <45AFE9D0.6060205@1006.org>
References: <4939.1164740825@sss.pgh.pa.us>
<45AFD927.9050605@janestcapital.com>
<45AFE9D0.6060205@1006.org>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: josh@agliodbs.com, pgsql-advocacy@postgresql.org, chris@1006.org, bhurt@janestcapital.com
Subject: Re: Postgres and really huge tables
In-Reply-To: <200701191604.13850.josh@agliodbs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox