Re: table clustering brings joy

Поиск
Список
Период
Сортировка
От Kevin Murphy
Тема Re: table clustering brings joy
Дата
Msg-id 4302962C.5000709@genome.chop.edu
обсуждение исходный текст
Ответ на Re: table clustering brings joy  (Greg Stark <gsstark@mit.edu>)
Ответы Re: table clustering brings joy  (Junaili Lie <junaili@gmail.com>)
Список pgsql-general
Greg Stark wrote:

>All that said clustering is indeed often quite effective. Especially if it
>makes an index scan efficient enough to win over sequential scans you can see
>some huge effects. It's most useful for tables that aren't undergoing lots of
>updates and don't need to be reclustered often.
>
>
Which is my situation; most tables are read-only.  Thanks for the comments.

-Kevin

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

Предыдущее
От: Matthew Terenzio
Дата:
Сообщение: syntax error foreign key
Следующее
От: Matthew Terenzio
Дата:
Сообщение: Re: syntax error foreign key