Re: cluster index on a table

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: cluster index on a table
Дата
Msg-id dcc563d10907151936y22d01025qcd27d6420c695d4@mail.gmail.com
обсуждение исходный текст
Ответ на Re: cluster index on a table  (Ibrahim Harrani <ibrahim.harrani@gmail.com>)
Ответы Re: cluster index on a table
Список pgsql-performance
I'd love to see it.

On Wed, Jul 15, 2009 at 8:17 PM, Justin Pitts<justinpitts@gmail.com> wrote:
> Is there any interest in adding that (continual/automatic cluster
> order maintenance) to a future release?
>
> On Wed, Jul 15, 2009 at 8:33 PM, Scott Carey<scott@richrelevance.com> wrote:
>> If you have a lot of insert/update/delete activity on a table fillfactor can
>> help.
>>
>> I don’t believe that postgres will try and maintain the table in the cluster
>> order however.
>>
>>
>> On 7/15/09 8:04 AM, "Ibrahim Harrani" <ibrahim.harrani@gmail.com> wrote:
>>
>> Hi,
>>
>> thanks for your suggestion.
>> Is there any benefit of setting fillfactor to 70 or 80 on this table?
>>
>>
>>
>> On Wed, Jun 24, 2009 at 8:42 PM, Scott Marlowe<scott.marlowe@gmail.com>
>> wrote:
>>> As another poster pointed out, you cluster on ONE index and one index
>>> only.  However, you can cluster on a multi-column index.
>>>
>>
>> --
>> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-performance
>>
>>
>



--
When fascism comes to America, it will be intolerance sold as diversity.

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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Performance comparison between Postgres and Greenplum
Следующее
От: "Raji Sridar (raji)"
Дата:
Сообщение: Concurrency issue under very heay loads