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
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 |
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 |