Re: [GENERAL] [PERFORM] PostgreSQL - case studies

2010-02-10 Thread Kevin Grittner 
Jayadevan M jayadevan.maym...@ibsplc.com 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)?
 
I'm a database administrator for the Wisconsin Courts.  We've got
about 200 PostgreSQL database clusters on about 100 servers spread
across the state.  Databases range from tiny (few MB) to 1.3 TB. 
 
Check out this for more info:
 
http://www.pgcon.org/2009/schedule/events/129.en.html
 
I hope that helps.  If you have any particular questions not
answered by the above, just ask.
 
-Kevin

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] [PERFORM] PostgreSQL - case studies

2010-02-10 Thread Stephen Frost 
* Kevin Grittner (kevin.gritt...@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


signature.asc
Description: Digital signature

Re: [GENERAL] [PERFORM] PostgreSQL - case studies

2010-02-10 Thread David Boreham 

Kevin Grittner (kevin.gritt...@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)?
  

At NuevaSync we use PG in a one-database-per-server design, with our own
replication system between cluster nodes. The largest node has more than 
200G online.

This is an OLTP type workload.







--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general