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

2009-02-21 Thread Andreas Kretschmer
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 on both machines and compare the output or show the output here. Andreas -- Really, I'm not out to destroy Microsoft. Th

[PERFORM] how the hdd read speed is related to the query execution speed.

2009-02-20 Thread sathiya psql
Hi, I have a 8 GB database, and 2 GB table. In a query i use the 2 GB table and several other tables where it takes around 90 minutes for execution. In different places, it takes drastically different time. Say everywhere i have the same, OS - Debian. Primary memory - 3 GB PostgreSQL configuratio