> -----Original Message-----
> From: Thomas Kellerer [mailto:spam_eater(at)gmx(dot)net]
> Sent: Tuesday, September 25, 2012 7:24 AM
> To: pgsql-performance(at)postgresql(dot)org
> Subject: Re: Postgres becoming slow, only full vacuum fixes it
> Kiriakos Tsourapas, 25.09.2012 13:01:
> > Thank you,
> > I will take this into consideration, since upgrading to 9 will be
> much harder I assume...
> I think an upgrade from 8.3 to 8.4 was "harder" due to the removal of a
> lot of implicit type casts.
> 8.4 to 9.x shouldn't be that problematic after all (but will take
> longer due to the required dump/reload)
Actually, 8.3 to 8.4 required db dump/restore.
When upgrading from 8.4 to 9.x pg_upgrade could be used without dump/restore.
In response to
pgsql-performance by date
|Next:||From: pg noob||Date: 2012-10-01 16:49:53|
|Subject: deadlock_timeout affect on performance|
|Previous:||From: henk de wit||Date: 2012-09-29 12:40:35|
|Subject: Re: Spurious failure to obtain row lock possible in PG