Re: Optimizer bug??
От | Gaetano Mendola |
---|---|
Тема | Re: Optimizer bug?? |
Дата | |
Msg-id | 40B39260.2060103@bigfoot.com обсуждение исходный текст |
Ответ на | Re: Optimizer bug?? (Josh Berkus <josh@agliodbs.com>) |
Список | pgsql-hackers |
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Josh Berkus wrote: | Gaetano, | | |>I just only suggesting to decrease that values that are oversized for a | | modern | |>hardware. | | | Hey, have you had success with those settings that you suggested? I've tried | tinkering with the relative CPU cost settings, and had mixed results. | That's why I have no particular recommmendation for them. | Usually yes, decreasing that values I'm able to decrease the index scan cost, so when I enable again the sequential scan the index one is choosed. Regards Gaetano Mendola -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFAs5Je7UpzwH2SGd4RAg/1AKCUYdTGIm5c7kG/ZXvmb49RWybs2ACgg3Wk zOHkWnCvbyPgeDCU3pn6UfQ= =Td0B -----END PGP SIGNATURE-----
В списке pgsql-hackers по дате отправления: