Re: Real time query analyzer

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: Real time query analyzer
Дата
Msg-id 20061018222258.GA56874@nasby.net
обсуждение исходный текст
Ответ на Re: Real time query analyzer  (Ron Johnson <ron.l.johnson@cox.net>)
Ответы Re: Real time query analyzer  (Ron Johnson <ron.l.johnson@cox.net>)
Список pgsql-general
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@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

В списке pgsql-general по дате отправления:

Предыдущее
От: Ken Tanzer
Дата:
Сообщение: Re: Strange behavior on non-existent field in subselect?
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: Real time query analyzer