Re: query tuning

Поиск
Список
Период
Сортировка
От Fernando Nasser
Тема Re: query tuning
Дата
Msg-id 1060969670.2357.4.camel@novo
обсуждение исходный текст
Ответ на query tuning  (Dave Cramer <dave@fastcrypt.com>)
Список pgsql-general
SET enable_seqscan TO FALSE;
<your query>
SET enable_seqscan TO TRUE;

Is this what you where looking for?

Regards,
Fernando


On Thu, 2003-08-14 at 08:00, Dave Cramer wrote:
> I have a query which definitely runs faster when sequential scans are
> turned off. Which parameters do I tune? and which way?
>
> After quickly perusing the docs, and google, I think it is the
> random_page_cost?
>
> Any help would be appreciated.
>
> Dave


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

Предыдущее
От: Jan Wieck
Дата:
Сообщение: Re: Why the duplicate messages to pgsql-general?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: join of array