Postgres Pro
Downloads
Home   >   mailing lists

Re: how the hdd read speed is related to the query execution speed. - Mailing list pgsql-performance

From Andreas Kretschmer
Subject Re: how the hdd read speed is related to the query execution speed.
Date
Msg-id 20090221083604.GA7392@tux
Whole thread Raw
In response to how the hdd read speed is related to the query execution speed.  (sathiya psql <sathiya.psql@gmail.com>)
List pgsql-performance
Tree view 
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°

pgsql-performance by date:

Previous
From: sathiya psql
Date:
Subject: how the hdd read speed is related to the query execution speed.
Next
From: Denis Lussier
Date:
Subject: Re: Benchmark comparing PostgreSQL, MySQL and Oracle