Postgres Pro
Downloads
Home   >   mailing lists

Thread: postgres 6.2 vacuum

postgres 6.2 vacuum

From
Hornyak Laszlo
Date:
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

Re: postgres 6.2 vacuum

From
Stephan Szabo
Date:
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.

Re: postgres 6.2 vacuum

From
"scott.marlowe"
Date:
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.

Re: postgres 6.2 vacuum

From
Hornyak Laszlo
Date:
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.
>