Re: Real time query analyzer

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Real time query analyzer
Дата
Msg-id 45369C39.3000700@cox.net
обсуждение исходный текст
Ответ на Re: Real time query analyzer  ("Jim C. Nasby" <jim@nasby.net>)
Ответы Re: Real time query analyzer
Список pgsql-general
-----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.

- --
Ron Johnson, Jr.
Jefferson LA  USA

Is "common sense" really valid?
For example, it is "common sense" to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that "common sense" is obviously wrong.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)

iD8DBQFFNpw5S9HxQb37XmcRAqUGAKCNMHXclyTP3Z2Bg5GIWF47xjc0IACg4YU6
KCtNVChdUo9NAJrf1aFVITw=
=+uon
-----END PGP SIGNATURE-----

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

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: UDF and cache
Следующее
От: Ken Tanzer
Дата:
Сообщение: Re: Strange behavior on non-existent field in subselect?