Re: [PERFORM] Joining views disables indexes?

2005-11-01 Thread Steinar H. Gunderson
On Tue, Nov 01, 2005 at 06:16:59PM -0500, Mitch Pirtle wrote: > 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 e

Re: [PERFORM] Joining views disables indexes?

2005-11-01 Thread Tom Lane
Mitch Pirtle <[EMAIL PROTECTED]> writes: > 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.

Re: [PERFORM] Joining views disables indexes?

2005-11-01 Thread Jim C. Nasby
On Tue, Nov 01, 2005 at 06:16:59PM -0500, Mitch Pirtle wrote: > 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 e

[PERFORM] Joining views disables indexes?

2005-11-01 Thread Mitch Pirtle
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