Re: Our CLUSTER implementation is pessimal

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Our CLUSTER implementation is pessimal
Дата
Msg-id 1220872291.3913.124.camel@ebony.2ndQuadrant
обсуждение исходный текст
Ответ на Re: Our CLUSTER implementation is pessimal  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Список pgsql-hackers
On Mon, 2008-09-08 at 13:52 +0300, Heikki Linnakangas wrote:
> Simon Riggs wrote:
> > I think there needs to be an option to force this to do either sorts or
> > indexscans. 
> 
> If we use the planner, "set enable_indexscan =off" or "set 
> enable_sort=off" ought to work.

Agreed - as long as that is explicitly in the docs.

I'm wondering whether we should put a limit on size of each temp
tablespace. This change will cause old admin jobs to break disks that
aren't big enough for the new way of doing it.

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Training, Services and Support



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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: [PATCH] Cleanup of GUC units code
Следующее
От: ITAGAKI Takahiro
Дата:
Сообщение: Re: Synchronous Log Shipping Replication