Query performance
От | Lou O'Quin |
---|---|
Тема | Query performance |
Дата | |
Msg-id | s2318583.040@mesagate.talleyds.com обсуждение исходный текст |
Ответы |
Re: Query performance
|
Список | pgsql-performance |
As a test, I ran a query in the pgAdmin query tool, which returns about 15K records from a PostgreSQL v8.01 table on my Win2K server.
I ran the same query from the local server, from another PC on the same 100 mbit local network, and from a PC on a different network, over the internet.
The times for the query to run and the data to return for each of the three
locations are shown here:
1 : 2.43 : 7.71
whereas the query execution time ratios are:
1 : 2.08 : 25.5 (!!!)
Obviously, the transport times will be greater. But why does the execution time bloat so?
I ran the same query from the local server, from another PC on the same 100 mbit local network, and from a PC on a different network, over the internet.
The times for the query to run and the data to return for each of the three
locations are shown here:
- Local Server : 571+521 ms
- Local network: 1187+1266 ms
- Internet:14579+4016 ms
1 : 2.43 : 7.71
whereas the query execution time ratios are:
1 : 2.08 : 25.5 (!!!)
Obviously, the transport times will be greater. But why does the execution time bloat so?
В списке pgsql-performance по дате отправления: