From: Gregory Stewart <gstewart@sweetdata.com>
To: Jim C. Nasby <jnasby@pervasive.com>
To: Mark Kirkwood <markir@paradise.net.nz>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance Issues on Opteron Dual Core
Date: Tue, 2 May 2006 23:27:02 -0500
Message-ID: <NBEMKBBMFBGPKAFFEILFIEANCDAA.gstewart@sweetdata.com> (raw)
In-Reply-To: <20060502202837.GC97354@pervasive.com>
Jim,
Have you seen this happening only on W2k3? I am wondering if I should try
out 2000 Pro or XP Pro.
Not my first choice, but if it works...
-----Original Message-----
From: Jim C. Nasby [mailto:jnasby@pervasive.com]
Sent: Tuesday, May 02, 2006 3:29 PM
To: Mark Kirkwood
Cc: Gregory Stewart; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Performance Issues on Opteron Dual Core
On Sun, Apr 30, 2006 at 10:59:56PM +1200, Mark Kirkwood wrote:
> Pgadmin can give misleading times for queries that return large result
> sets over a network, due to:
>
> 1/ It takes time to format the (large) result set for display.
> 2/ It has to count the time spent waiting for the (large) result set to
> travel across the network.
>
> You aren't running Pgadmin off the dev server are you? If not check your
> network link to dev and prod - is one faster than the other? (etc).
>
> To eliminate Pgadmin and the network as factors try wrapping your query
> in a 'SELECT count(*) FROM (your query here) AS a', and see if it
> changes anything!
FWIW, I've found problems running PostgreSQL on Windows in a multi-CPU
environment on w2k3. It runs fine for some period, and then CPU and
throughput drop to zero. So far I've been unable to track down any more
information than that, other than the fact that I haven't been able to
reproduce this on any single-CPU machines.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.5.1/328 - Release Date: 5/1/2006
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: gstewart@sweetdata.com, jnasby@pervasive.com, markir@paradise.net.nz
Subject: Re: Performance Issues on Opteron Dual Core
In-Reply-To: <NBEMKBBMFBGPKAFFEILFIEANCDAA.gstewart@sweetdata.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox