On 10/10/06, Jim C. Nasby <jim@xxxxxxxxx> wrote:
> >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... You can also turn timing on in psql. And FWIW, RAID5 generally isn't a good idea for databases.
thats just our development box here at the office. production system runs on something much more extravagent :). melrin
