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