Re: [SQL] How Postgresql Compares For Some Query Types

2001-07-18 Thread markir
> > 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

Re: [SQL] How Postgresql Compares For Some Query Types

2001-07-17 Thread Josh Berkus
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