Hi Emmanuel, Even if I eliminate the recovery log from postgresql I am still not clear how do I get the following time results:
POSTGRESQL - LOG FILE: ---------------------- 0.758 ms: select * from mysp($1,$2,$3,$4,$5,$6) 7.758 ms: COMMIT SEQUOIA - RECOVERY LOG: ----------------------- 5 ms: call mysp($1,$2,$3,$4,$5,$6) 0 ms: commit Thanks you very much for your time, Ioana --- Emmanuel Cecchet <[EMAIL PROTECTED]> wrote: > Hi Ioana, > > I am a little bit confused about the time > displayed in > > statistics. I have a stored procedure that I > execute > > twice through sequoia and for the second execution > of > > the procedure the time in statistics and recovery > log > > it seems to be much smaller than the time > displayed in > > the postgres log! Can somebody tell me what I am > > missing here? > > > Yes, the execution time you see in Sequoia is the > time perceived by the > client but there are cache effects and asynchronous > execution that > affects execution time. > Recovery log updates are fully asynchronous meaning > that recovery log > updates will never be accounted in query execution > time. Also the > metadatache will prevent re-fetching ResultSet > metadata (very slow on > Postgres) when the query is executed for the 2nd > time. > Most of the query execution time that appears in > your Postgres log is > due to the recovery log but this happens > asynchronously (in parallel) > while the result is being return to the client. > > Hope this clarifies things, > Emmanuel > > -- > Emmanuel Cecchet > Chief Scientific Officer, Continuent > > Blog: http://emanux.blogspot.com/ > Open source: http://www.continuent.org > Corporate: http://www.continuent.com > Skype: emmanuel_cecchet > Cell: +33 687 342 685 > > > _______________________________________________ > Sequoia mailing list > [email protected] > https://forge.continuent.org/mailman/listinfo/sequoia > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
