Re: [PERFORM] Crashing DB or Server?

2005-12-16 Thread Moritz Bayer
Hi, actually every SELECT statements takes a couple of minutes. For example SELECT * FROM pg_stat_activity already takes 260 sec. And the IOWAIT value increases just after  starting the postmaster, no querys are processed. I started vacuumizing the tables of the DB.  Still, it doesn't make a d

[PERFORM] Crashing DB or Server?

2005-12-16 Thread Moritz Bayer
Hello group, I've got a really bad problem with my postgres DB and server. It is a linux machine with 1GB of RAM and 2 CPUs. The postgres Version is 7.4. The problem is, that once the postmaster has started, the System is just about useless. At least querys to the db are so slow, that it most oft