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