>
> 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 : observ
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