| 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: | Whole Thread | Raw Message | 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.
>
| 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 |