[PERFORM] when benchmarking insert , can there be caching effects?

Hi, when benchmarking insert , can there be caching effects? i insert, delete again, and insert again. does anything cache the things that i deleted? (postgres 8.4 on debian) cheers, WBL -- "Patriotism is the conviction that your country is superior to all others because you were born in it."

Re: [PERFORM] when benchmarking insert , can there be caching effects?

Willy-Bas Loos wrote: > when benchmarking insert , can there be caching effects? Yes. > i insert, delete again, and insert again. > does anything cache the things that i deleted? Yes. How long you wait before another attempt could have a significant effect on timings. There are backgrou