Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 5132F632FD5 for ; Thu, 17 Jun 2010 20:17:54 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 49686-07 for ; Thu, 17 Jun 2010 23:17:47 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 24DBA632A99 for ; Thu, 17 Jun 2010 20:17:47 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o5HNHjGT028021; Thu, 17 Jun 2010 19:17:45 -0400 (EDT) To: Brant Fitzsimmons cc: pgsql-performance@postgresql.org Subject: Re: Add slowdown after conversion to UTF8 In-reply-to: References: Comments: In-reply-to Brant Fitzsimmons message dated "Thu, 17 Jun 2010 18:28:53 -0400" Date: Thu, 17 Jun 2010 19:17:45 -0400 Message-ID: <28020.1276816665@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201006/321 X-Sequence-Number: 39177 Brant Fitzsimmons writes: > I've searched the web and can find very little on this issue, so I was > hoping those on this list would be able to shed some light on it. > Performance has dropped through the floor after converting my db from ASCI > to UTF8. Is this normal behavior on 8.4.x? Well, with no specifics on performance of *what*, it's hard to say. There are certain operations that could be quite a bit slower, yes. I haven't heard of too many people noticing a problem though. It's probably worth noting that locale could be at least as much of a factor as encoding ... but perhaps I'm jumping to conclusions about what your slow operations are. regards, tom lane