Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 3C1C3476036 for ; Tue, 26 Feb 2002 10:15:20 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id g1QFF4S29765; Tue, 26 Feb 2002 10:15:04 -0500 (EST) To: Brian McCane Cc: pg-admin Subject: Re: Performance question In-reply-to: <20020226033228.B17694-100000@fw.mccons.net> References: <20020226033228.B17694-100000@fw.mccons.net> Comments: In-reply-to Brian McCane message dated "Tue, 26 Feb 2002 03:39:10 -0600" Date: Tue, 26 Feb 2002 10:15:04 -0500 Message-ID: <29762.1014736504@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200202/350 X-Sequence-Number: 3503 Brian McCane writes: > Since I am using a strict alphabet like this, would it be faster to build > PostgreSQL without Multibyte support? Or has the indexing, etc. been > optimized so much for multibyte that it is actually faster than single > byte stuff? A non-multibyte build will certainly be faster than a multibyte build. How much is hard to say, especially without any specific operation mix in mind. We'd be interested to hear what sort of results you get ... regards, tom lane