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 по дате отправления:

Предыдущее
От: Gaetano Mendola
Дата:
Сообщение: Re: Optimizer bug??
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Optimizer bug??