Ja tentei de tudo e o windows esta com a melhor performance do que o
Suse.
Windows Total runtime:
12.584 ms
Linux Opensuse Total runtime: 21.498 ms
Comando Explain.
| Desempnho Linux Open Suse |
Desempenho Windows |
"Sort (cost=73.08..73.63
rows=220 width=91) (actual time=19.293..20.354 rows=220 loops=1)"
" Sort Key: veiculos.placa"
" -> Hash Left Join (cost=33.83..64.52 rows=220 width=91) (actual
time=9.711..17.751 rows=220 loops=1)"
" Hash Cond: ("outer"."Motorista" =
("inner"."CDPESSOA")::bpchar)"
" -> Hash Left
Join (cost=20.55..48.78 rows=220 width=119)
(actual time=6.826..12.580 rows=220 loops=1)"
" Hash Cond:
(("outer".placa)::bpchar = "inner"."Cavalo")"
" -> Hash
Left Join (cost=7.26..22.96 rows=220 width=65)
(actual time=2.970..6.427 rows=220 loops=1)"
" Hash Cond:
(("outer".placa)::text = ("inner".placa)::text)"
" -> Seq
Scan on veiculos (cost=0.00..6.20 rows=220
width=11) (actual time=0.011..1.151 rows=220 loops=1)"
" -> Hash (cost=6.61..6.61 rows=261 width=64) (actual
time=2.933..2.933 rows=261 loops=1)"
" ->
Seq Scan on ultimapos (cost=0.00..6.61
rows=261 width=64) (actual time=0.007..1.412 rows=261 loops=1)"
" -> Hash (cost=12.43..12.43 rows=343 width=108) (actual
time=3.827..3.827 rows=343 loops=1)"
" -> Seq
Scan on relacao (cost=0.00..12.43 rows=343
width=108) (actual time=0.007..1.876 rows=343 loops=1)"
" -> Hash (cost=12.62..12.62 rows=262 width=33) (actual
time=2.856..2.856 rows=262 loops=1)"
" -> Seq
Scan on "MOTORIST" (cost=0.00..12.62 rows=262
width=33) (actual time=0.006..1.411 rows=262 loops=1)"
"Total runtime: 21.498 ms" |
"Sort (cost=234.70..235.25
rows=220 width=89) (actual time=11.844..12.034 rows=220 loops=1)"
" Sort Key: veiculos.placa"
" -> Hash Left Join (cost=218.65..226.14 rows=220 width=89) (actual
time=8.563..11.006 rows=220 loops=1)"
" Hash Cond: ("outer"."Motorista" =
("inner"."CDPESSOA")::bpchar)"
" -> Merge
Left Join (cost=154.38..159.39 rows=220
width=117) (actual time=7.041..8.855 rows=220 loops=1)"
" Merge Cond: ("outer"."?column5?"
= "inner"."Cavalo")"
" -> Sort (cost=94.50..95.05 rows=220 width=63) (actual
time=4.213..4.410 rows=220 loops=1)"
" Sort Key:
(veiculos.placa)::bpchar"
" -> Hash
Left Join (cost=31.26..85.95 rows=220 width=63)
(actual time=1.607..2.849 rows=220 loops=1)"
" Hash Cond:
(("outer".placa)::text = ("inner".placa)::text)"
" ->
Seq Scan on veiculos (cost=0.00..32.20
rows=220 width=11) (actual time=0.018..0.579 rows=220 loops=1)"
" ->
Hash (cost=30.61..30.61 rows=261
width=62) (actual time=1.553..1.553 rows=261 loops=1)"
" -> Seq Scan on ultimapos (cost=0.00..30.61
rows=261 width=62) (actual time=0.265..0.889 rows=261 loops=1)"
" -> Sort (cost=59.87..60.73 rows=343 width=108) (actual
time=2.803..3.110 rows=343 loops=1)"
" Sort Key: relacao."Cavalo""
" -> Seq
Scan on relacao (cost=0.00..45.43 rows=343
width=108) (actual time=0.027..0.789 rows=343 loops=1)"
" -> Hash (cost=63.62..63.62 rows=262 width=33) (actual
time=1.481..1.481 rows=264 loops=1)"
" -> Seq
Scan on "MOTORIST" (cost=0.00..63.62 rows=262
width=33) (actual time=0.183..0.845 rows=264 loops=1)"
"Total runtime: 12.584 ms" |
|
_______________________________________________
Grupo de Usuários do PostgreSQL no Brasil
Antes de perguntar consulte o manual
http://pgdocptbr.sourceforge.net/
Para editar suas opções ou sair da lista acesse a página da lista em:
http://pgfoundry.org/mailman/listinfo/brasil-usuarios
