pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Gregory Williamson <Gregory.Williamson@digitalglobe.com>
To: Elvis HenrĂ­quez <henriquez.elvis@gmail.com>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Case studies
Date: Wed, 28 Nov 2007 03:32:21 -0700
Message-ID: <8B319E5A30FF4A48BE7EEAAF609DB233015E2FC9@COMAIL01.digitalglobe.com> (raw)
References: <493343bd0711261934p43fe15f9q46aaae78c8b6ddd4@mail.gmail.com>
	<dcc563d10711262212q56655981w1bfd63f6c4c0dc0d@mail.gmail.com>
	<493343bd0711271832l7ddf96cx57a91bd082717a28@mail.gmail.com>

FWIW, we've got a billing database with several moderate tables, one is 48 million rows with about 75k per day; and some much larger tables that are effectively partitioned by date so that some client software (Excel, etc.) doesn't choke on them. And we've got some spatial tables that dwarf the billing stuff.

The case studies you looked at all still valid, really, if you think about it -- PostgreSQL has gotten *better* with successive releases, and has also gotten faster. So fewer worries and more speed. If 7.4.x could handle something it is almost certain that 8.2 can do so as well and probably better.

You might also take a quick look at the case studies for the PostGIS extension at <http://postgis.refractions.net/documentation/casestudies/;. (The GlobeXplorer stuff is us; DigitalGlobe is now using PostgreSQL as well.)

We migrated from Informix 9.3 some years ago (mainly due to cost) and haven't regretted it.

Greg Williamson
Senior DBA
GlobeXplorer, a DigitalGlobe Company

(some legal disclaimers snipped since this is a public mail ... please excuse the top-posting but this is a lame reader and the post I am responding to was top-posted so at least this is consistent)

-----Original Message-----
From: pgsql-admin-owner@postgresql.org on behalf of Elvis HenrĂ­quez
Sent: Tue 11/27/2007 7:32 PM
To: Scott Marlowe
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Case studies
 
That's what I'm telling to them, but they want proven results in other
companies, but I'll manage it.

Thanks for your reply and information.

Best regards.

On Nov 27, 2007 2:12 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> That's actually pretty small.  Where I work we have a data warehouse
> of similar design (a few large tables, a few small lookup tables).  It
> has 86,840,447 rows and takes up 44 Gigs of space.  It sits on a
> single CPU box with a 4 disk RAID-10 and runs queries covering a few
> minutes to a few days worth of monitoring data.  Sequential scanning
> the whole main table takes 621 seconds or so (10+ minutes).  We add
> 150 to 200k rows a day to it.
>
> Selecting a days's worth of data takes ~ 350ms.  A week's worth takes
> 2 to 10 seconds depending on how much is cached.
>
> This is a small database for either oracle or postgresql.  Talk your
> bosses into giving postgresql a try if you can.  You should be able to
> build a 20million test database in an afternoon or so, so it's not
> like you'll be dedicating thousands of man hours to test it.
>

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

view thread (7+ messages)  latest in thread

Message-ID: <8B319E5A30FF4A48BE7EEAAF609DB233015E2FC9@COMAIL01.digitalglobe.com>
Permalink:  ../8B319E5A30FF4A48BE7EEAAF609DB233015E2FC9@COMAIL01.digitalglobe.com/
Also on:    postgresql.org/message-id/8B319E5A30FF4A48BE7EEAAF609DB233015E2FC9@COMAIL01.digitalglobe.com

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: Gregory.Williamson@digitalglobe.com, henriquez.elvis@gmail.com, scott.marlowe@gmail.com
  Subject: Re: Case studies
  In-Reply-To: <8B319E5A30FF4A48BE7EEAAF609DB233015E2FC9@COMAIL01.digitalglobe.com>
  References: <493343bd0711261934p43fe15f9q46aaae78c8b6ddd4@mail.gmail.com> <dcc563d10711262212q56655981w1bfd63f6c4c0dc0d@mail.gmail.com> <493343bd0711271832l7ddf96cx57a91bd082717a28@mail.gmail.com> <8B319E5A30FF4A48BE7EEAAF609DB233015E2FC9@COMAIL01.digitalglobe.com>

* 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