Skip site navigation (1) Skip section navigation (2)

Re: Case studies

From: Elvis Henríquez <henriquez(dot)elvis(at)gmail(dot)com>
To: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Case studies
Date: 2007-11-28 02:32:01
Message-ID: 493343bd0711271832l7ddf96cx57a91bd082717a28@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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(dot)marlowe(at)gmail(dot)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.
>

In response to

Responses

pgsql-admin by date

Next:From: Gregory WilliamsonDate: 2007-11-28 10:32:21
Subject: Re: Case studies
Previous:From: Elvis HenríquezDate: 2007-11-28 02:28:59
Subject: Re: Case studies

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group