Re: White paper on very big databases - Mailing list pgsql-advocacy

From Greg Smith
Subject Re: White paper on very big databases
Date
Msg-id Pine.GSO.4.64.0902051517580.7882@westnet.com
Whole thread Raw
In response to White paper on very big databases  (Jean-Paul Argudo <jean-paul@postgresqlfr.org>)
List pgsql-advocacy
At Truviso I work on a 3.8TB database where the largest table is 1.3TB of
data and 0.8TB of index.  I have some paperwork to do before I could
really give out any real details, will look into that.  The biggest
challenge was loading all that data into there in the first place (it was
2TB from day one), as COPY isn't very fast.  That is particularly
unfortunate because that's the same path the dump/reload needed for a
version update would need to take.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

pgsql-advocacy by date:

Previous
From: Jonathan Fuerth
Date:
Subject: Re: [sfpug] Anyone do video streaming / podcasting?
Next
From: Brad Nicholson
Date:
Subject: Re: White paper on very big databases