Re: Refined LC_COLLATE or multiple database clusters?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Grega Bremec <grega(dot)bremec(at)noviforum(dot)si>
Cc: pgsql-admin(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Refined LC_COLLATE or multiple database clusters?
Date: 2004-06-09 13:53:32
Message-ID: 20467.1086789212@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

Grega Bremec <grega(dot)bremec(at)noviforum(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message David F. Skoll 2004-06-09 14:09:27 Dump only part of a DB
Previous Message Tom Lane 2004-06-09 13:46:41 Re: [Fwd: Re: RHDB just sits and does nothing?]

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-06-09 13:56:18 Re: Question regarding dynamic_library_path
Previous Message Bruce Momjian 2004-06-09 13:36:26 Re: thread safety tests