Обсуждение: Re: [ADMIN] Refined LC_COLLATE or multiple database clusters?

Поиск
Список
Период
Сортировка

Re: [ADMIN] Refined LC_COLLATE or multiple database clusters?

От
Tom Lane
Дата:
Grega Bremec <grega.bremec@noviforum.si> writes:
> Collate order for those databases, however, needs to be different.

If you need multiple LC_COLLATE settings then you have to run multiple
postmasters.  There is no other solution today, nor likely to be one in
the near future.

> Also, running several postmasters on this same machine is not an option,

Sure it is.  Just don't go overboard with the shared_buffers settings.
Let the kernel do the bulk of the buffering and you'll be fine.

            regards, tom lane