Hi Everyone,
I have come across a very sticky situation which is very concerning,
and frustrating. The server we run - AMD Opteron, 2GB RAM, 2x CPU's,
runs Postgres, Apache and PHP to run our web applications.
Last week I upgraded from Postgres 7.4.2 to Postgres 8 and have been
running beutifully since then (last wed). For some reason today, my web
app has been incredibly slow, and now that I'm trying to diagnose the
problem, I've had the entire server hang. I completely stopped all
processes and started from scratch on starting PG and Apache.
I have not been able to exit PG and have had to kill processes.
Any help would be GREATLY appreciated.
Regards,
James
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
