Matthew Lunnon wrote:
Ah I was afraid of that. Maybe I'll have to come out of the dark ages.
At the very least, upgrade to latest 7.4 minor version. It probably
won't help with you're performance, but 7.4.3 is very old. There's been
a *lot* of bug fixes between 7.4.3 and 7.4.18, including fixes for
security vulnerabilities and data corruption bugs.
Steinar H. Gunderson wrote:
On Wed, Dec 12, 2007 at 10:16:43AM +0000, Matthew Lunnon wrote:
Does anyone have any ideas what my bottle neck might be and what I
can do about it?
Your bottleneck is that you are using a very old version of
PostgreSQL. Try
8.2 or (if you can) the 8.3 beta series -- it scales a _lot_ better in
this
kind of situation.
/* Steinar */
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
