Re: how the hdd read speed is related to the query execution speed.

sathiya psql <sathiya.psql@gmail.com> schrieb:
> can some body give me ideas on what to do for confirming what is the issue for
> consuming much time for the query execution ?

Run

EXPLAIN ANALYSE <your query> on both machines and compare the output or
show the output here.


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°