Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 66C462E0361 for ; Thu, 7 Feb 2008 12:32:20 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 63602-03-5 for ; Thu, 7 Feb 2008 12:32:17 -0400 (AST) Received: from mail.mailpen.net (mail.mailpen.net [209.90.228.14]) by postgresql.org (Postfix) with ESMTP id 9073C2E0084 for ; Thu, 7 Feb 2008 12:32:16 -0400 (AST) Received: from [172.24.2.1] (pool-71-113-24-134.sttlwa.dsl-w.verizon.net [71.113.24.134]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.mailpen.net (Postfix) with ESMTP id 9240E2FE802 for ; Thu, 7 Feb 2008 08:32:14 -0800 (PST) Message-ID: <47AB32A7.6050406@ultimeth.com> Date: Thu, 07 Feb 2008 08:32:39 -0800 From: "Dean Gibson (DB Administrator)" Organization: UltiMeth Systems User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: 8.3.0, locales, and encodings References: <47AA6CEE.4010406@ultimeth.com> <20080207091746.GC21225@easy2.in-chemnitz.de> In-Reply-To: <20080207091746.GC21225@easy2.in-chemnitz.de> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200802/77 X-Sequence-Number: 28151 On 2008-02-07 01:17, Tino Schwarze wrote: > Hi Dean, > > On Wed, Feb 06, 2008 at 06:29:02PM -0800, Dean Gibson (DB Administrator) wrote: > >> 2. ... Should I be running INITDB w/ "-locale POSIX -E UTF8", or just "-locale POSIX" (implying "-E SQL_ASCII")? Or does it make a difference, since I always specify the desired database encoding when I "CREATE DATABASE... ENCODING '...';"? >> > > AFAIK, it shouldn't make a difference. -E is just the default encoding for new databases. > > Actually, "-E" also affects the encoding of the base PostgreSQL databases. W/o "-E": => \l List of databases Name | Owner | Encoding -----------+----------+----------- postgres | postgres | SQL_ASCII template0 | postgres | SQL_ASCII template1 | postgres | SQL_ASCII If I INITDB /w "-E UTF8": => \l List of databases Name | Owner | Encoding -----------+----------+---------- postgres | postgres | UTF8 template0 | postgres | UTF8 template1 | postgres | UTF8 So, the interesting question is, does the difference in the encoding of the base databases affect performance or capability in any way? -- Dean