From: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Real time query analyzer |
Date: | 2006-10-18 21:27:21 |
Message-ID: | 45369C39.3000700@cox.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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-----
From | Date | Subject | |
---|---|---|---|
Next Message | Ken Tanzer | 2006-10-18 21:59:25 | Re: Strange behavior on non-existent field in subselect? |
Previous Message | Jim C. Nasby | 2006-10-18 21:19:29 | Re: UDF and cache |