I wrote:
> Alexander Lakhin <exclus...@gmail.com> writes:
>> explain (verbose, analyze)
>> select
>>   (select max((select i.unique2 from tenk1 i where i.unique1 = o.unique1)))
>> from tenk1 o;
>> -- original tenk1
>>  Execution Time: 4769.481 ms

> Hm, I get about 13 ms for that example.  Do you have some really
> expensive debugging infrastructure enabled, perhaps?

Oh, never mind, now I see you are testing a version of the table
with no indexes, rather than the way it's set up in the regression
database.  Apologies for the noise.

                        regards, tom lane


Reply via email to