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
|Next:||From: Sean Davis||Date: 2008-10-02 23:52:36|
|Subject: Re: PostgreSQL for Data Warehouse|
|Previous:||From: Mark Wimer||Date: 2008-10-01 15:21:24|
|Subject: Re: absolute novice wanting knowledgeable opinion about front end|