Re: TB-sized databases

Поиск
Список
Период
Сортировка
От Decibel!
Тема Re: TB-sized databases
Дата
Msg-id 7C49F3E2-DD15-4C3A-879C-956B7504F257@decibel.org
обсуждение исходный текст
Ответ на Re: TB-sized databases  (Bill Moran <wmoran@collaborativefusion.com>)
Список pgsql-performance
On Nov 28, 2007, at 7:27 AM, Bill Moran wrote:
> Is there something wrong with:
> set enable_seqscan = off


Note that in cases of very heavy skew, that won't work. It only adds
10M to the cost estimate for a seqscan, and it's definitely possible
to have an index scan that looks even more expensive.
--
Decibel!, aka Jim C. Nasby, Database Architect  decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828



Вложения

В списке pgsql-performance по дате отправления:

Предыдущее
От: Decibel!
Дата:
Сообщение: Re: autovacuum: recommended?
Следующее
От: Mark Cave-Ayland
Дата:
Сообщение: Re: Evaluation of PG performance vs MSDE/MSSQL 2000 (not 2005)