Skip site navigation (1)
Skip section navigation (2)
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
Peripheral Links
Header And Logo
|
Site Navigation
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: Thu, 31 Aug 2006 19:10:02 -0400
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
- Prev by Date: Re: Why so long between archive calls?
- Next by Date: Re: Strange message followed by server crash
- Previous by thread: archive logs recovery
- Indexes: