I'm a little unclear on what a fact table is. Can you explain?
Good question... The idea comes from data warehousing where a typical data
construction involves two types of table :
dimensions : time, location, ethicity( essentially denormalized lookups )
facts :
Dear list,
With the advent of Version 7.1.2 I thought it would be interesting to compare
how Postgresql does a certain class of queries (Star Queries), and Data Loads
with some of the other leading databases ( which were in my humble opinion
Mysql 3.23.39, Db2 7.2 ,Oracle 9.0 [ ok - Possibly
Mark, (and Tom below)
Thanks for doing the tests. These'll be useful to me if any client
asks me again if PostgreSQL is a real database. I'm particularly
intrigued that MySQL performed so poorly. In the field, it's been quite
speedy but maybe that's because applications using it are