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

Postgres and really huge tables

From: Brian Hurt <bhurt(at)janestcapital(dot)com>
To: pgsql-performance(at)postgresql(dot)org, pgsql-advocacy(at)postgresql(dot)org
Subject: Postgres and really huge tables
Date: 2007-01-18 20:31:35
Message-ID: 45AFD927.9050605@janestcapital.com (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-performance
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?

We have a problem of that form here.  When I asked why postgres wasn't 
being used, the opinion that postgres would "just <explicitive> die" was 
given.  Personally, I'd bet money postgres could handle the problem (and 
better than the ad-hoc solution we're currently using).  But I'd like a 
couple of replies of the form "yeah, we do that here- no problem" to 
wave around.

Brian



In response to

Responses

pgsql-performance by date

Next:From: Joshua D. DrakeDate: 2007-01-18 20:39:45
Subject: Re: Postgres and really huge tables
Previous:From: Jeremy HaileDate: 2007-01-18 20:21:47
Subject: Re: Autoanalyze settings with zero scale factor

pgsql-advocacy by date

Next:From: Joshua D. DrakeDate: 2007-01-18 20:39:45
Subject: Re: Postgres and really huge tables
Previous:From: Robert BernierDate: 2007-01-12 15:27:38
Subject: Re: New liveCD?

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