Re: PostgreSQL for Data Warehouse
| От | Jasmin Dizdarevic |
|---|---|
| Тема | Re: PostgreSQL for Data Warehouse |
| Дата | |
| Msg-id | a0eee4d40810081429p678cac8p923c9c823c736880@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: PostgreSQL for Data Warehouse (Mark Roberts <mailing_lists@pandapocket.com>) |
| Ответы |
Re: PostgreSQL for Data Warehouse
|
| Список | pgsql-novice |
Hi Mark,
thank you for your information. That sound's great!
May I know your hardware configuration on which this database is running?
Jasmin
On Wed, Oct 8, 2008 at 11:21 PM, Mark Roberts <mailing_lists@pandapocket.com> wrote:
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.
>
--
Mit freundlichen Grüßen
Dizdarevic Jasmin
Sonnenbergstr. 3
6714 Nüziders, AUT
jasmin.dizdarevic@gmail.com
+43 664 411 79 29
В списке pgsql-novice по дате отправления: