From: Elvis HenrĂquez <henriquez.elvis@gmail.com>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Case studies
Date: Tue, 27 Nov 2007 22:32:01 -0400
Message-ID: <493343bd0711271832l7ddf96cx57a91bd082717a28@mail.gmail.com> (raw)
In-Reply-To: <dcc563d10711262212q56655981w1bfd63f6c4c0dc0d@mail.gmail.com>
References: <493343bd0711261934p43fe15f9q46aaae78c8b6ddd4@mail.gmail.com>
<dcc563d10711262212q56655981w1bfd63f6c4c0dc0d@mail.gmail.com>
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.
>
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: henriquez.elvis@gmail.com, scott.marlowe@gmail.com
Subject: Re: Case studies
In-Reply-To: <493343bd0711271832l7ddf96cx57a91bd082717a28@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