Postgres Pro
Downloads
Home   >   mailing lists

Thread: postgresql 8.4.1 running very slow after converting to UTF8

postgresql 8.4.1 running very slow after converting to UTF8

From
Julian Tree
Date:
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