Re: odd variances in count(*) times - Mailing list pgsql-performance

* Merlin Moncure (mmoncure@gmail.com) 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