Re: [PERFORM] odd variances in count(*) times

[Stephen Frost]

* Merlin Moncure ([EMAIL PROTECTED]) wrote:
> explain analyze select 5000!;
> A: 2.4 seconds
> B: 1.8 seconds
> 
> explain analyze select count(*) from generate_series(1,500000);
> A: 0.85 seconds
> B: 4.94 seconds

Try w/o the explain analyze.  It adds quite a bit of overhead and that
might be inconsistant between the systems (mainly it may have to do with
the gettimeofday() calls being implemented differently between Windows
and Linux..).

        Thanks,

                Stephen

signature.asc
Description: Digital signature