server slowdown
Posted: Sat Jul 05, 2008 1:05 am
Ok, so I had been noticing that this server was often slow lately, due to postgresql activity.
Just investigated, and it turned out that there wasn't an index on the id column topics table, and queries on that were taking forever. Just added it, and now that same query is going *much* faster.
Wonder what happened that the index got dropped ... but anyway I hope it's solved now.
Just investigated, and it turned out that there wasn't an index on the id column topics table, and queries on that were taking forever. Just added it, and now that same query is going *much* faster.
Wonder what happened that the index got dropped ... but anyway I hope it's solved now.