Re: odd variances in count(*) times

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



* Merlin Moncure (mmoncure@xxxxxxxxx) 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

Attachment: signature.asc
Description: Digital signature


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux