Re: [PERFORM] execution time for first INSERT

2011-07-08 Thread Jeff Davis
On Fri, 2011-07-08 at 04:23 -0700, Sergio Mayoral wrote: > this must be something with the parser stage and since i am doing > every time the same queries, I would like to know if there is a way to > cache these queries in order to speed up the first INSERT. I doubt it's the parser. Seeing as it'

[PERFORM] execution time for first INSERT

2011-07-08 Thread Sergio Mayoral
Hi, i am using libpq library and postgresql 8.4 for my linux application running on ARM with 256 MB. I am just doing: PQconnectdb(); PQexec(INSERT INTO table1 ); (0.009661 sec.) PQexec(INSERT INTO table1 ); (0.004208 sec.) PQexec(INSERT INTO table2 ); (0.007352 sec.) PQexec(INSERT I