Re: Case studies

["Elvis Henríquez" <henriquez(dot)elvis(at)gmail(dot)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(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.
>