Re: query tuning

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: query tuning
Дата
Msg-id 20030814134826.GD27870@wolff.to
обсуждение исходный текст
Ответ на query tuning  (Dave Cramer <Dave@micro-automation.net>)
Список pgsql-general
Please don't reply to messages to start a new thread.

On Thu, Aug 14, 2003 at 08:09:23 -0400,
  Dave Cramer <Dave@micro-automation.net> 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?

Have you run vacuum analyze?

Can you supply a copy of the query and explain analyze output?

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

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: importing db as text files
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: importing db as text files