I wrote:
> Alexander Lakhin <exclusion(at)gmail(dot)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