Skip site navigation (1) Skip section navigation (2)

postgres 6.2 vacuum

From: Hornyak Laszlo <kocka(at)tigrasoft(dot)hu>
To: pgsql-admin(at)postgresql(dot)org
Subject: postgres 6.2 vacuum
Date: 2003-09-22 16:07:01
Message-ID: Pine.LNX.4.21.0309221801420.1000-100000@tiger.tigrasoft.hu (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-hackers
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


Responses

pgsql-hackers by date

Next:From: Stephan SzaboDate: 2003-09-22 16:16:19
Subject: Re: postgres 6.2 vacuum
Previous:From: Patrick WelcheDate: 2003-09-22 16:03:28
Subject: Re: missing pg_clog files ?

pgsql-admin by date

Next:From: Kris KigerDate: 2003-09-22 16:14:55
Subject: libpq problem
Previous:From: Jodi KanterDate: 2003-09-22 15:44:55
Subject: steps to ensure referential integrity

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group