Postgres Pro
Downloads
Home   >   mailing lists

postgresql 8.4.1 running very slow after converting to UTF8 - Mailing list pgsql-admin

From Julian Tree
Subject postgresql 8.4.1 running very slow after converting to UTF8
Date
Msg-id 78B19E11-9330-428A-84BB-B48C79D4AAC2@gmail.com
Whole thread Raw
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Why so long between archive calls?
Next
From: Tom Lane
Date:
Subject: Re: Strange message followed by server crash