Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 986456326BC for ; Fri, 18 Jun 2010 01:09:22 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 22857-03 for ; Fri, 18 Jun 2010 04:09:15 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by mail.postgresql.org (Postfix) with SMTP id 4EF88632410 for ; Fri, 18 Jun 2010 01:09:15 -0300 (ADT) Received: (qmail invoked by alias); 18 Jun 2010 04:09:13 -0000 Received: from unknown (EHLO [192.168.0.4]) [204.210.253.91] by mail.gmx.net (mp014) with SMTP; 18 Jun 2010 06:09:13 +0200 X-Authenticated: #495269 X-Provags-ID: V01U2FsdGVkX1+eU8pTHPOen50Ow9heuHaFNXXrVxQHqRdql8g7mv Mhq3HZ5NJfz8Rp Subject: Re: Add slowdown after conversion to UTF8 From: Peter Eisentraut To: Brant Fitzsimmons Cc: pgsql-performance@postgresql.org In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Date: Fri, 18 Jun 2010 00:09:04 -0400 Message-ID: <1276834144.10286.6.camel@vanquo.pezone.net> Mime-Version: 1.0 X-Mailer: Evolution 2.30.1.2 Content-Transfer-Encoding: 7bit X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.79 tagged_above=-10 required=5 tests=BAYES_50=0.8, RCVD_IN_DNSWL_NONE=-0.0001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201006/327 X-Sequence-Number: 39183 On tor, 2010-06-17 at 18:28 -0400, Brant Fitzsimmons wrote: > Performance has dropped through the floor after converting my db from > ASCI to UTF8. Converting from ASCII to UTF8 is a noop. If you did some configuration changes, you need to tell us which.