Re: PostgreSQL for Data Warehouse - Mailing list pgsql-novice

From Mark Roberts
Subject Re: PostgreSQL for Data Warehouse
Date
Msg-id 1223500862.12105.554.camel@localhost
Whole thread Raw
In response to PostgreSQL for Data Warehouse  ("Jasmin Dizdarevic" <jasmin.dizdarevic@gmail.com>)
Responses Re: PostgreSQL for Data Warehouse
List 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.
>


pgsql-novice by date:

Previous
From: "Wright, George"
Date:
Subject: threads question
Next
From: "Jasmin Dizdarevic"
Date:
Subject: Re: PostgreSQL for Data Warehouse