Re: Queries joining views

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alban Hertroys <alban(at)magproductions(dot)nl>
Cc: DelGurth <delgurth(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Queries joining views
Date: 2006-08-22 13:21:46
Message-ID: 2446.1156252906@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Alban Hertroys <alban(at)magproductions(dot)nl> writes:
> However, mm_product.number always matches either mm_insrel.snumber or
> mm_insrel.dnumber (source and destination respectively). The other way
> around this isn't the case; then snumber and dnumber match number-fields
> in other tables (they always do).

Oh, then we are looking at the wrong things: we should be comparing the
histograms of the fields that are being used as the join keys in this
query. I had thought they were both "number", but I must be confused.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Silvela, Jaime (Exchange) 2006-08-22 13:30:50 Re: could not open relation - why?
Previous Message Alban Hertroys 2006-08-22 13:08:09 Re: Queries joining views

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2006-08-22 13:25:12 Re: seahorse again failing
Previous Message Tom Lane 2006-08-22 13:19:13 Re: seahorse again failing