On Fri, Aug 07, 2009 at 04:17:18PM +0200, Pierre Frrrdddric Caillaud wrote:
> I'm answering my own question : at the beginning of the run, postgres
> creates a 800MB temporary file, then it fills the table, then deletes the
> temp file.
> Is this because I use generate_series to fill the test table ?
Doh, yes. A function's result is written to temp location first and
then read back again once the function returns success. You'll have
more luck if you do:
SELECT now() + '1 sec'::INTERVAL, (1+random()*99998),
random()*10000000,n+random()*10000, n+random()*1000, n
FROM (
SELECT generate_series( 1, 60000000 )) x(n);
--
Sam http://samason.me.uk/