pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Elvis HenrĂ­quez <henriquez.elvis@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Case studies
Date: Tue, 27 Nov 2007 00:12:27 -0600
Message-ID: <dcc563d10711262212q56655981w1bfd63f6c4c0dc0d@mail.gmail.com> (raw)
In-Reply-To: <493343bd0711261934p43fe15f9q46aaae78c8b6ddd4@mail.gmail.com>
References: <493343bd0711261934p43fe15f9q46aaae78c8b6ddd4@mail.gmail.com>

On Nov 26, 2007 9:34 PM, Elvis HenrĂ­quez <henriquez.elvis@gmail.com> wrote:
> Hello everybody.
>
> Rather than asking for a technical detail or writing about a problem,
> I'm asking for up-to-date case studies involving PostgreSQL.
>
> The company where I'm actually working is migrating some apps; one
> requires a Data Warehouse, and I'm proposing PostgreSQL, but they're
> thinking of Oracle, as the system has one table (among others) with 20
> fields and more then 19 millions of records, and this exists for 2
> subcompanies, which are actually in different databases, but the
> migration project implies joining the two subcompanies data.
>
> This amount of data is the result of 8 years of usage, and the data
> growing rate has increased in the last two years.

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.



view thread (7+ messages)  latest in thread

Message-ID: <dcc563d10711262212q56655981w1bfd63f6c4c0dc0d@mail.gmail.com>
Permalink:  ../dcc563d10711262212q56655981w1bfd63f6c4c0dc0d@mail.gmail.com/
Also on:    postgresql.org/message-id/dcc563d10711262212q56655981w1bfd63f6c4c0dc0d@mail.gmail.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 using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: scott.marlowe@gmail.com, henriquez.elvis@gmail.com
  Subject: Re: Case studies
  In-Reply-To: <dcc563d10711262212q56655981w1bfd63f6c4c0dc0d@mail.gmail.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