<span style=" font-family:'courier new'; font-size: 9pt;">Hi<br /><br /> >> >> The test performs about 11K
linesof code<br /> >> >> Oracle: about 5M<br /> >> >> postgreSql: about 160М<br /><br /><br />
>Whatis the actual O/S that PostgreSQL is installed on? <br /> >How much total memory is on the server? <br />
>Iwould be very curious about the values you have specified in postgresql.conf?<br /> > Also, what is the exact
versionof PostgreSQL you are using?<br /> >What is the total time to complete the test for all 3 DB's?<br /> >The
bestI can tell is that with all the unknowns, you are comparing apples to oranges.<br /><br /> There is real problem
forus.<br /><span style=" font-family:'verdana';">The PL/pgSQL interpreter parses the function's source text and
producesan internal binary instruction tree the first time the function is called (within each session)<span style="
font-family:'timesnew roman'; font-size: 14pt;"> <br /><br /><span style=" font-family:'Courier New'; font-size:
9pt;">Thesize of this instruction tree depends only of postgreSql build.<br /><br /> And size is big, and size is not
sharebetween session.<br /><br /> I understand that nobody says: Damn One second I will implement it soon :)<br /><br
/>Thank all for constructive answers.</span></span></span></span>