Joining views disables indexes?

From: Mitch Pirtle <mitch(dot)pirtle(at)gmail(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Joining views disables indexes?
Date: 2005-11-01 23:16:59
Message-ID: 330532b60511011516u3709d826w391a4ac167c6967b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jim C. Nasby 2005-11-01 23:23:14 Re: Joining views disables indexes?
Previous Message Geoffrey 2005-11-01 23:12:36 Re: solutions for new Postgresql application testing