From: | Tino Wildenhain <tino(at)wildenhain(dot)de> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Greg Stark <stark(at)enterprisedb(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Hannu Krosing <hannu(at)2ndquadrant(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Christian Schröder <cs(at)deriva(dot)de>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [GENERAL] Performance of full outer join in 8.3 |
Date: | 2009-04-18 22:36:54 |
Message-ID: | 49EA5606.5020002@wildenhain.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Tom Lane wrote:
> Greg Stark <stark(at)enterprisedb(dot)com> writes:
...
>> I suppose if we had explain-to-a-table then we could run explain and
>> then run an sql query to verify the specific properties we were
>> looking for.
>
>> A similar thing could be done with xml if we had powerful enough xml
>> predicates but we have a lot more sql skills in-house than xml.
>
> Yeah, I suspect the only really good answers involve the ability to
> apply programmable checks to the EXPLAIN output. A SQL-based solution
> shouldn't need any external moving parts, whereas analyzing XML output
> presumably would.
If only an explain-to-a-table would be one of the available options
and not the only option that would be great. The big O only has this
option and it totally sux if you want to explain a query on a production
environment where you can't just create tables here and there.
Tino
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2009-04-19 00:26:04 | Re: Nooby Q: Should this take five hours? And counting? |
Previous Message | Kenneth Tilton | 2009-04-18 22:11:28 | Nooby Q: Should this take five hours? And counting? |
From | Date | Subject | |
---|---|---|---|
Next Message | KaiGai Kohei | 2009-04-19 01:28:45 | Re: [PATCH] unalias of ACL_SELECT_FOR_UPDATE |
Previous Message | Greg Stark | 2009-04-18 22:33:49 | Re: 8.4b1: Query returning results in different order to 8.3 |