Voce conseguiu um milagre...
Vamos encaminhar isto ao Vaticano, eheheh
Abraços
Stefan
2006/11/29, Mateus <[EMAIL PROTECTED]>:
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.63rows=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.61rows=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.20rows=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
--
Stefan Horochovec
_______________________________________________
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
