Re: Real time query analyzer

On Wed, Oct 18, 2006 at 04:27:21PM -0500, Ron Johnson wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On 10/18/06 16:08, Jim C. Nasby wrote:
> > On Mon, Oct 16, 2006 at 06:10:18PM +0300, Adrian Suciu wrote:
> >> Hi everybody!
> >> I ask you for your help on a problem I have.
> >> I have a postgresql 7.4 running on a dual 4 GB RAM server, but I have
> >> some VERY memory intense queries, that put processor up to 40%. I see
> >
> > Note that you're likely to see double the performance of 7.4 by going to
> > 8.1.5. You'll likely get an even larger gain from 8.2 when it's out.
>
> What's the release target for 8.2?
>
> (If I get approval and the money, we'll be creating a roughly 8TB
> database, and in-place upgrade is the only way that we'd be able to
> migrate from $EXISTING_VERSION to $NEW_VERSION.

There's been very few (any?) bugs reported against beta1, so it could
potentially be Real Soon Now. If forced to guess, I'd say mid-November,
but of course the real answer is "when it's ready".

There's also talk of an in-place upgrade tool for 8.1 to 8.2.

In any case, you'll be much, much happier if you do this project on at
least 8.1.x, as 7.4 is pretty long in the tooth. Due to Red Hat's
support requirements it will probably remain supported for a few more
years by Tom/the community, but you might start having issues getting
commercial support.

Are you planning on backing up straight to tape?
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)