pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Gavin Sherry <swm@alcove.com.au>
To: Brian Hurt <bhurt@janestcapital.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgres and really huge tables
Date: Fri, 19 Jan 2007 10:09:57 +1100 (EST)
Message-ID: <Pine.LNX.4.58.0701191006530.3671@linuxworld.com.au> (raw)
In-Reply-To: <45AFD927.9050605@janestcapital.com>
References: <4939.1164740825@sss.pgh.pa.us>
	<200611282344.kASNijt09203@momjian.us>
	<456CE066.50803@cheapcomplexdevices.com>
	<456D8A65.3080400@janestcapital.com>
	<1164812624.9690.500.camel@archimedes>
	<456DA476.4000606@janestcapital.com>
	<456DB8C9.7020206@cheapcomplexdevices.com>
	<45AFD927.9050605@janestcapital.com>

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



view thread (10+ messages)  latest in thread

Message-ID: <Pine.LNX.4.58.0701191006530.3671@linuxworld.com.au>
Permalink:  ../Pine.LNX.4.58.0701191006530.3671@linuxworld.com.au/
Also on:    postgresql.org/message-id/Pine.LNX.4.58.0701191006530.3671@linuxworld.com.au

 · 

reply
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: swm@alcove.com.au, bhurt@janestcapital.com
  Subject: Re: Postgres and really huge tables
  In-Reply-To: <Pine.LNX.4.58.0701191006530.3671@linuxworld.com.au>

* 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