Hi Andres, By executing #explain analyze execute test_query; the first execution cost 0.389 seconds the second cost 0.285 seconds Greetings, Ning On Thu, Jul 16, 2009 at 4:45 PM, Andres Freund<andres@xxxxxxxxxxx> wrote: > On Thursday 16 July 2009 03:11:29 ning wrote: >> Hi Andres, >> >> The log for the test you suggested is as follows in PostgreSQL8.2.4, >> but I cannot find a clue to prove or prove not PostgreSQL is doing >> plan caching. > Well. How long is the PREPARE and the EXECUTEs taking? > > > Andres > -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
