"Ilja Golshtein" <ilejn@yandex.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