Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres becoming slow, only full vacuum fixes it - Mailing list pgsql-performance

From Thomas Kellerer
Subject Re: Postgres becoming slow, only full vacuum fixes it
Date
Msg-id k3s489$drh$1@ger.gmane.org
Whole thread Raw
In response to Re: Postgres becoming slow, only full vacuum fixes it  (Kiriakos Tsourapas <ktsour@gmail.com>)
Responses Re: Postgres becoming slow, only full vacuum fixes it  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: Postgres becoming slow, only full vacuum fixes it  (Igor Neyman <ineyman@perceptron.com>)
List pgsql-performance
Tree view 
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)

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: hardware advice
Next
From: Evgeny Shishkin
Date:
Subject: wrong join result set estimate