Re: The order of fields around the "=" in the WHERE

From: "Mike Quinn" <mquinn(at)co(dot)merced(dot)ca(dot)us>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: The order of fields around the "=" in the WHERE
Date: 2006-04-04 17:18:30
Message-ID: 443247F6020000E5000001E6@dp_mail.co.merced.ca.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

The datatype of the join columns is a user defined type and there are no
commutators defined. I will fix that and retest. Thanks for the
insight.

Mike Quinn

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andrus 2006-04-04 19:37:18 Query runs too long for indexed tables
Previous Message Simon Riggs 2006-04-04 15:35:14 Re: vacuum full seems to hang on very small table