Re: what is the cause that scan type is showing as 'seq scan' after

Поиск
Список
Период
Сортировка
От Gaetano Mendola
Тема Re: what is the cause that scan type is showing as 'seq scan' after
Дата
Msg-id 3FF973FC.6030004@bigfoot.com
обсуждение исходный текст
Ответ на Re: what is the cause that scan type is showing as 'seq scan' after  (Joseph Lemm <joelemm@yahoo.com>)
Список pgsql-admin
Joseph Lemm wrote:

> Gaetano, thanks.
>
> My db has only one table (about 29,000 records), so I thought leaving
> postgreqsql.conf at its defaults would be OK: the params you mention are
> commented out, so they must be at their defaults, tho I can't tell what the
> defaults are.

The values on the line commented are the default values.

> Are there any docs that talk specificially about how to set these params and
> what the defaults are (the official docs don't say  much)?


Take a look at performance NG, at least is what I use to do.



Regards
Gaetano Mendola









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

Предыдущее
От: "Andrzej Schulz"
Дата:
Сообщение: Postgres & XML
Следующее
От: "Glenn Wiorek"
Дата:
Сообщение: Re: what is the cause that scan type is showing as 'seq scan' after