Обсуждение: postgres 6.2 vacuum
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
On Mon, 22 Sep 2003, Hornyak Laszlo wrote: > 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. You might be better off dropping indexes, vacuuming and then recreating the indexes.
On Mon, 22 Sep 2003, Hornyak Laszlo wrote: > 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 :( In all honesty, it'd probably be faster to convert than to wait for that vacuum to finish. seriously. 6.2 is like the model A of Postgresql versions.
Yes, at the end we did the port at night, and in the morning the system started without any problem. Some of the dumps from pg 6.2 was not realy acceptable by 7.3, but it was easy to fix. Thank you for your help! Laszlo Hornyak On Tue, 23 Sep 2003, scott.marlowe wrote: > On Mon, 22 Sep 2003, Hornyak Laszlo wrote: > > > 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 :( > > In all honesty, it'd probably be faster to convert than to wait for that > vacuum to finish. > > seriously. > > 6.2 is like the model A of Postgresql versions. >