Re: 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(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.
>