| 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: | Whole Thread | Raw Message | 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 |