Re: [PERFORM] PostgreSQL - case studies - Mailing list pgsql-general

From Stephen Frost
Subject Re: [PERFORM] PostgreSQL - case studies
Date
Msg-id 20100210155503.GB17756@tamriel.snowman.net
Whole thread Raw
In response to Re: [PERFORM] PostgreSQL - case studies  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: [PERFORM] PostgreSQL - case studies
List pgsql-general
* Kevin Grittner (Kevin.Grittner@wicourts.gov) wrote:
> > Could some of you please share some info on such scenarios- where
> > you are supporting/designing/developing databases that run into at
> > least a few hundred GBs of data (I know, that is small by todays'
> > standards)?

Just saw this, so figured I'd comment:

tsf=> \l+
                                                              List of databases
   Name    |  Owner   | Encoding |  Collation  |    Ctype    |     Access privileges      |  Size   | Tablespace  |
  Description         

-----------+----------+----------+-------------+-------------+----------------------------+---------+-------------+---------------------------
 beac      | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/postgres               | 1724 GB | pg_default  |

Doesn't look very pretty, but the point is that its 1.7TB.  There's a
few other smaller databases on that system too.  PG handles it quite
well, though this is primairly for data-mining.

    Thanks,

        Stephen

Attachment

pgsql-general by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: [PERFORM] PostgreSQL - case studies
Next
From: Yeb Havinga
Date:
Subject: Re: Orafce concat operator