X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 608FC9DC84D for ; Tue, 7 Mar 2006 11:48:57 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 48624-09 for ; Tue, 7 Mar 2006 11:49:01 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from web53903.mail.yahoo.com (web53903.mail.yahoo.com [206.190.36.126]) by postgresql.org (Postfix) with SMTP id 5765D9DCC0E for ; Tue, 7 Mar 2006 11:48:54 -0400 (AST) Received: (qmail 55609 invoked by uid 60001); 7 Mar 2006 15:48:59 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=S51mPWUa5sQsXgLgIfmTlRNlTD8Po1emSvkSVYdxBXpp7JgyBhU84/pNUnE7pBfDGyx2xqgf6WibNQD3naV/ujOxeSEK1XLDtNAnj3PkEUdNYrfG/3vT6dqXWZi/2OxrxaTaHLl+k2+hWRPlvXA8+Ir5FSgt7qJ2K2J6uqX6t9w= ; Message-ID: <20060307154859.55607.qmail@web53903.mail.yahoo.com> Received: from [24.188.184.164] by web53903.mail.yahoo.com via HTTP; Tue, 07 Mar 2006 07:48:59 PST Date: Tue, 7 Mar 2006 07:48:59 -0800 (PST) From: ow Subject: Re: New database: SQL_ASCII vs UTF-8 trade-offs To: pgsql-admin@postgresql.org In-Reply-To: <18241.1141742995@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.138 required=5 tests=[AWL=-0.220, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_WHOIS=0.879] X-Spam-Score: 1.138 X-Spam-Level: * X-Archive-Number: 200603/69 X-Sequence-Number: 20826 --- Tom Lane wrote: > ow writes: > > Are there any negative effects related to the selection of UTF-8 over > SQL_ASCII > > There will be a speed penalty; whether it's significant in your > application is something you can only determine by experiment. I see... If *ALL* data is in ASCII, is it possible to just update "pg_database.encoding" to UTF-8 or will I need to recreate the db? Thanks __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com