Re: Buld Insert and Index use.

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Buld Insert and Index use.
Дата
Msg-id 200408111725.55270.josh@agliodbs.com
обсуждение исходный текст
Ответ на Buld Insert and Index use.  (Rudi Starcevic <tech@wildcash.com>)
Список pgsql-performance
Rudi,

> Do you think an Index or Seq. scan should be used?

That was way too much data for way too simple a question.  ;-)
The answer is: depends on how many rows you have.   With any significant
number of rows, yes.

However, you probably only need to index the first 3-5 columns; that's
selective enough.

--
-Josh Berkus
 "A developer of Very Little Brain"
 Aglio Database Solutions
 San Francisco


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

Предыдущее
От: Gaetano Mendola
Дата:
Сообщение: Re: [HACKERS] fsync vs open_sync
Следующее
От: "Jason Coene"
Дата:
Сообщение: Re: Hardware upgrade for a high-traffic database