| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Greg Smith <gsmith(at)gregsmith(dot)com> |
| Cc: | Clodoaldo <clodoaldo(dot)pinto(dot)neto(at)gmail(dot)com>, PostgreSQL General ML <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Performance problem. Could it be related to 8.3-beta4? |
| Date: | 2008-01-07 22:23:18 |
| Message-ID: | 26371.1199744598@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Greg Smith <gsmith(at)gregsmith(dot)com> writes:
> The only thing I noticed in your original explain plans that was different
> between the two was:
> 8.2:
> Merge Cond: ((ut.n_time = ui.n_time) AND
> ((ut.usuario)::text = "inner"."?column4?"))
> 8.3:
> Merge Cond: ((ut.n_time = ui.n_time) AND
> ((ut.usuario)::text = (ui.usuario_nome)::text))
I believe that is just a cosmetic change: the EXPLAIN code in 8.2 and
before tended to punt (and print "?columnN?") for any but the simplest
references to subplan node outputs, whereas 8.3 will (in theory) get it
right all the time. With no other visible differences, there's no
reason to think these plans are different.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Devrim GÜNDÜZ | 2008-01-07 22:32:00 | Announcing PostgreSQL RPM Yum Repository |
| Previous Message | Peter Eisentraut | 2008-01-07 21:59:42 | Re: Announcing PostgreSQL RPM Buildfarm |