| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | josh(at)agliodbs(dot)com |
| Cc: | Oleg Lebedev <oleg(dot)lebedev(at)waterford(dot)org>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: TPC-R benchmarks |
| Date: | 2003-10-08 04:15:57 |
| Message-ID: | 29371.1065586557@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Josh Berkus <josh(at)agliodbs(dot)com> writes:
> To sum up the below: it appears that whenever a set of WHERE conditions
> exceeds a certain level of complexity, the planner just ignores all
> applicable indexes and goes for a seq scan.
It looks to me like the planner is coercing the WHERE clause into
canonical OR-of-ANDs form (DNF). Which is often a good heuristic
but it seems unhelpful for this query.
> How can we fix this?
Feel free to propose improvements to the heuristics in
src/backend/optimizer/prep/prepqual.c ...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff | 2003-10-08 12:36:56 | Sun performance - Major discovery! |
| Previous Message | Josh Berkus | 2003-10-07 23:59:17 | Re: TPC-R benchmarks |