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

От: Andreas Kretschmer
Тема: Re: how the hdd read speed is related to the query execution speed.
Дата: ,
Msg-id: 20090221083604.GA7392@tux
(см: обсуждение, исходный текст)
Ответ на: how the hdd read speed is related to the query execution speed.  (sathiya psql)
Список: pgsql-performance

sathiya psql <> 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°


В списке pgsql-performance по дате сообщения:

От: Grzegorz Jaśkiewicz
Дата:
Сообщение: Re: not in(subselect) in 8.4
От: decibel
Дата:
Сообщение: Re: Partial index usage