X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id E74659FB446 for ; Thu, 31 Aug 2006 20:10:21 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 12362-01 for ; Thu, 31 Aug 2006 20:10:18 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.237]) by postgresql.org (Postfix) with ESMTP id 172259FB42A for ; Thu, 31 Aug 2006 20:10:17 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id t13so814535wxc for ; Thu, 31 Aug 2006 16:10:15 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:mime-version:content-transfer-encoding:message-id:content-type:to:from:subject:date:x-mailer; b=hB9Cp8+f4wwCQcp7cvP02cogy9zFqToKP++s9wkgWf0ZRWiUSkVDWqFYmVgMzIo9FotYtSWLdF0qDBRDv5ks36xICltbNrNSqBYbiJehqBVyGIXvLmDmiVsMd6aU8ZBnQJjmAixukW2p/NMHOYESwXFVSfLJlHYnamFeCOLWOrU= Received: by 10.70.74.1 with SMTP id w1mr1459080wxa; Thu, 31 Aug 2006 16:10:14 -0700 (PDT) Received: from ?192.168.254.27? ( [69.22.232.120]) by mx.gmail.com with ESMTP id i36sm1897744wxd.2006.08.31.16.10.14; Thu, 31 Aug 2006 16:10:14 -0700 (PDT) Mime-Version: 1.0 (Apple Message framework v752.2) Content-Transfer-Encoding: 7bit Message-Id: <78B19E11-9330-428A-84BB-B48C79D4AAC2@gmail.com> Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed To: pgsql-admin@postgresql.org From: Julian Tree Subject: postgresql 8.4.1 running very slow after converting to UTF8 Date: Thu, 31 Aug 2006 19:10:02 -0400 X-Mailer: Apple Mail (2.752.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.2 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/370 X-Sequence-Number: 22913 The same database was running fine in ASCII, but now it is taking up 90% CPU doing a few sum and select. I tried VACUMM but it didn't help. Dumping the database back to ASCII makes it go faster. Any ideas