Hi all! We have a database on postgreSQL 6.2 and it is extremely slow, so we started vacuum on it. I know it locks the tables, so clients can not use it until the process is finished, but it is extremely slow on a 1.800.000 record table and we don't know how to make it faster. Can anybody help me?
It seems it is writing an index file, but it grows very slowly. I know we should use 7.3 at least, we are working on it, but we need to survive this day with 6.2 :( Thanks in advance Laszlo Hornyak ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])