sathiya psql <sathiya(dot)psql(at)gmail(dot)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 ?
EXPLAIN ANALYSE <your query> on both machines and compare the output or
show the output here.
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°
In response to
pgsql-performance by date
|Next:||From: Grzegorz Jaśkiewicz||Date: 2009-02-21 11:49:31|
|Subject: Re: not in(subselect) in 8.4|
|Previous:||From: sathiya psql||Date: 2009-02-21 07:14:38|
|Subject: how the hdd read speed is related to the query execution speed.|