From: | Michelle Konzack <linux4michelle(at)tamay-dogan(dot)net> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: PostgreSQL for Data Warehouse |
Date: | 2008-10-08 00:59:43 |
Message-ID: | 20081008005943.GC21095@tamay-dogan.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Am 2008-10-03 00:28:40, schrieb Jasmin Dizdarevic:
> 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
I have not a warehouse but a WAR database where I had for 100 years one
table... The table from the last century had let me re-thinking...
2.5 mio rows with arround 240 columns and 43 languages had killed all.
It was a SINGEL table of arround 800 MByte.
Thanks, Greetings and nice Day/Evening
Michelle Konzack
Systemadministrator
24V Electronic Engineer
Tamay Dogan Network
Debian GNU/Linux Consultant
--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack Apt. 917 ICQ #328449886
+49/177/9351947 50, rue de Soultz MSN LinuxMichi
+33/6/61925193 67100 Strasbourg/France IRC #Debian (irc.icq.com)
From | Date | Subject | |
---|---|---|---|
Next Message | Bastiaan Olij | 2008-10-08 01:11:04 | Re: Canceling statement due to user request? |
Previous Message | Bastiaan Olij | 2008-10-07 22:12:15 | Canceling statement due to user request? |