| From: | "Matt Clark" <matt(at)ymogen(dot)net> |
|---|---|
| To: | "Jenny Zhang" <jenny(at)osdl(dot)org>, <josh(at)agliodbs(dot)com> |
| Cc: | "perf-pgsql" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: osdl-dbt3 run results - puzzled by the execution |
| Date: | 2003-09-19 10:41:55 |
| Message-ID: | OAEAKHEHCMLBLIDGAFELMEACDLAA.matt@ymogen.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
> I put the EXPLAIN ANALYZE output at:
> http://developer.osdl.org/~jenny/large_explain_analyze
> http://developer.osdl.org/~jenny/small_explain_analyze
> The actual execution time is 37 seconds(large) vs 5 seconds (small).
>
There's an obvious row count misestimation in the 'large' plan:
-> Sort (cost=519.60..520.60 rows=400 width=31) (actual time=106.88..143.49 rows=30321 loops=1)
but I'm not good enough at reading these things to tell if that's the cause of the problem, or if so how to fix it :-(
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oleg Bartunov | 2003-09-19 10:51:49 | NuSphere and PostgreSQL for windows |
| Previous Message | Carlos Guzman Alvarez | 2003-09-19 10:24:49 | Re: Array Parameters on protocol 3.0 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Stark | 2003-09-19 13:12:27 | Re: osdl-dbt3 run results - puzzled by the execution plans |
| Previous Message | Manfred Koizar | 2003-09-19 08:57:10 | Re: rewrite in to exists? |