| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgreSQL(dot)org, pgsql-performance(at)postgreSQL(dot)org |
| Subject: | Re: [PERFORM] Proposal: relaxing link between explicit JOINs and execution order |
| Date: | 2003-01-23 00:17:41 |
| Message-ID: | 200301221617.41680.josh@agliodbs.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
Tom,
I am very strongly in favor of this idea. I would personally prefer it if
the Join collapsing parmeter could be set at query time through a SET
statement, but will of course defer to the difficulty level in doing so.
> Comments? In particular, can anyone think of pithy names for these
> variables? The best I'd been able to come up with is MAX_JOIN_COLLAPSE
> and MAX_FROM_COLLAPSE, but neither of these exactly sing...
How about:
EXPLICIT_JOIN_MINIMUM
and
FROM_COLLAPSE_LIMIT
Just to make the two params not sound so identical?
--
-Josh Berkus
Aglio Database Solutions
San Francisco
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-01-23 00:18:07 | Re: Terrible performance on wide selects |
| Previous Message | Dann Corbit | 2003-01-23 00:06:26 | Re: Terrible performance on wide selects |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-01-23 00:18:07 | Re: Terrible performance on wide selects |
| Previous Message | Dann Corbit | 2003-01-23 00:06:26 | Re: Terrible performance on wide selects |