Re: [ADMIN] postgres 6.2 vacuum

I wonder if we should have an auto-responder so when someone says they
are running 6.5, we can reply --- Yikes, upgrade.

In fact, we could go with a little chart:

7.3.4 great
7.3.0-3 please upgrade, it is easy
7.2 consider upgrading
7.1 wow, that is old
7.0 you need an upgrade, pal
<=6.5 run, don't walk, to the nearest PostgreSQL ftp server

---------------------------------------------------------------------------

Hornyak Laszlo wrote:
>
> 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.
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073