Re: Clustering system catalog indexes
От | Bruce Momjian |
---|---|
Тема | Re: Clustering system catalog indexes |
Дата | |
Msg-id | 200405200143.i4K1hMe09781@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Clustering system catalog indexes (Christopher Kings-Lynne <chriskl@familyhealth.com.au>) |
Ответы |
Re: Clustering system catalog indexes
Re: Clustering system catalog indexes |
Список | pgsql-hackers |
Christopher Kings-Lynne wrote: > Is it worth us marking any system catalog indexes as clusterable by > default for performance? Not sure. Most of the system stuff is loaded in a pretty good order, and cluster is only good if you are going after seveal rows of identical value or similar value in the same table, and I can't think of a case where this would help. Can others? It is a good question. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania19073
В списке pgsql-hackers по дате отправления: