these
queries at once? I also presume that if VM usage is high then we are
paging a vast amount to disk. But I am not sure why.
Has anyone seen this behaviour before and can anyone point me in the
right direction?
Regards,
Alexander Stanier
---(end of broadcast
.
Tom Lane wrote:
Alexander Stanier [EMAIL PROTECTED] writes:
The database seems to fine to start with, but then as the load increases
it seems to reach a threshold where the number of non-idle queries in
pg_stat_activity grows heavily and we appear to get something similar to
a motorway
| 8
3100 |13
2314 | 2
(40 rows)
I guess it might be worth us getting this server up to PostgreSQL 8.0.3.
At least we can then discount that as a problem.
Regards, Alex Stanier.
Tom Lane wrote:
Alexander Stanier [EMAIL PROTECTED] writes:
The problem happened again this morning
