On 10/9/06, Stephen Frost <sfrost@xxxxxxxxxxx> wrote:
* 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..).
that was it. amd system now drop to .3 seconds, windows .6. (doing time foo > psql -c bar > file). thanks... merlin
