Skip site navigation (1) Skip section navigation (2)

Re: Postgres and really huge tables

From: Gavin Sherry <swm(at)alcove(dot)com(dot)au>
To: Brian Hurt <bhurt(at)janestcapital(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres and really huge tables
Date: 2007-01-18 23:09:57
Message-ID: Pine.LNX.4.58.0701191006530.3671@linuxworld.com.au (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-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

In response to

pgsql-performance by date

Next:From: Arjen van der MeijdenDate: 2007-01-19 06:15:12
Subject: Re: Configuration Advice
Previous:From: Luke LonerganDate: 2007-01-18 22:41:30
Subject: Re: Postgres and really huge tables

pgsql-advocacy by date

Next:From: Denis LussierDate: 2007-01-19 05:09:40
Subject: EnterpriseDB Apology
Previous:From: Luke LonerganDate: 2007-01-18 22:41:30
Subject: Re: Postgres and really huge tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group