Re: PostgreSQL for Data Warehouse

From: Mark Roberts <mailing_lists(at)pandapocket(dot)com>
To: Jasmin Dizdarevic <jasmin(dot)dizdarevic(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: PostgreSQL for Data Warehouse
Date: 2008-10-08 21:21:02
Message-ID: 1223500862.12105.554.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hmm,

I'm seeing about 20M facts/day input into the system I work on (and
we've been going for a few years now) and our average response time is
pretty snappy (<15s for the most common use cases).

IIRC, the online part of the database is ~2.5-3TB right now.

-Mark

On Fri, 2008-10-03 at 00:28 +0200, Jasmin Dizdarevic wrote:
> Hi,
>
> i'm actually evaluating different dbms for data warehouse tasks.
> has anybody expirience with it?
>
> i have to store 50 mio. records p.m. in a fact table.
> something like this:
>
> date; cust; group; product; value
>
> ...with unique index on date,cust,group,product.
>
> will there be any problem's in response time in let's say 12 months?
>
> thank you very much.
>

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Jasmin Dizdarevic 2008-10-08 21:29:18 Re: PostgreSQL for Data Warehouse
Previous Message Wright, George 2008-10-08 19:28:11 threads question