CLUSTER all tables at once?

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема CLUSTER all tables at once?
Дата
Msg-id Pine.LNX.4.44.0208121643440.11085-100000@cm-lcon1-46-187.cm.vtr.net
обсуждение исходный текст
Ответы Re: CLUSTER all tables at once?
Re: CLUSTER all tables at once?
Список pgsql-hackers
Hello

In TODO there is an item that says "cluster all tables at once".  Might
I ask, how is the system supposed to know on which indexes does it have
to cluster each table?

Maybe if some index had the indisclustered bit set one could select
that; but is it possible for some table to have more than one index with
it?  Intuition (but no code observation) says no.  And what happens with
those tables that do not have any such index?

-- 
Alvaro Herrera (<alvherre[a]atentus.com>)
"Oh, great altar of passive entertainment, bestow upon me thy discordant images
at such speed as to render linear thought impossible" (Calvin a la TV)



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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: [GENERAL] Linux Largefile Support In Postgresql RPMS
Следующее
От: Joe Conway
Дата:
Сообщение: Oracle releasing clustered file system code