postgresql 8.4.1 running very slow after converting to UTF8

From: Julian Tree <julian(dot)tree(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: postgresql 8.4.1 running very slow after converting to UTF8
Date: 2006-08-31 23:10:02
Message-ID: 78B19E11-9330-428A-84BB-B48C79D4AAC2@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2006-09-01 02:01:36 Re: Strange message followed by server crash
Previous Message Tom Lane 2006-08-31 21:18:13 Re: Why so long between archive calls?