Re: slow parsing of queries with joins

"Ilja Golshtein" <ilejn(at)yandex(dot)ru> writes:
> I faced with the fact PG parses some of my queries very slowly.
> I mean VERY VERY slowly (for example, MS SQL is about 50 times
> faster here).

> I used this script for small investigation.

Seems to be mostly fixed already. Using your script, I get

PG 8.0.3:

0:01.81 for 50 iterations
0:08.30 for 100 iterations
0:23.59 for 150 iterations
0:53.45 for 200 iterations
1:41.43 for 250 iterations
2:58.99 for 300 iterations

CVS tip:

0:00.10 for 50 iterations
0:00.23 for 100 iterations
0:00.70 for 150 iterations
0:01.22 for 200 iterations
0:01.58 for 250 iterations
0:02.36 for 300 iterations

regards, tom lane