I have a client that is testing an internal data platform, and they were happy with PostgreSQL until they tried to join views - at that time they discovered PostgreSQL was not using the indexes, and the queries took 24 hours to execute as a result. Is this a known issue, or is this possibly a site-specific problem? They just implemented the exact same datamodel in MySQL 5.0, with views and InnoDB tables, and performance is still subsecond. Would love to know if this is a known issue. -- Mitch
