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

From Gavin Sherry
Subject Re: Postgres and really huge tables
Date
Msg-id Pine.LNX.4.58.0701191006530.3671@linuxworld.com.au
Whole thread Raw
In response to Postgres and really huge tables  (Brian Hurt <bhurt@janestcapital.com>)
List pgsql-performance
Hi Brian,

On Thu, 18 Jan 2007, Brian Hurt wrote:

> Is there any experience with Postgresql and really huge tables?  I'm
> talking about terabytes (plural) here in a single table.  Obviously the
> table will be partitioned, and probably spread among several different
> file systems.  Any other tricks I should know about?

Here is a blog post from a user who is in the multi-tb range:

http://www.lethargy.org/~jesus/archives/49-PostreSQL-swelling.html

I think Theo sums up some of the pros and cons well.

Your best bet is a test on scale. Be sure to get our feed back if you
encounter issues.

Gavin

pgsql-performance by date:

Previous
From: "Luke Lonergan"
Date:
Subject: Re: [pgsql-advocacy] Postgres and really huge tables
Next
From: Arjen van der Meijden
Date:
Subject: Re: Configuration Advice