X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 080719FAE4E for ; Wed, 3 May 2006 01:27:20 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 12511-08 for ; Wed, 3 May 2006 01:27:04 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail4.intermedia.net (mail4.intermedia.net [206.40.48.154]) by postgresql.org (Postfix) with ESMTP id 0962E9FA7B6 for ; Wed, 3 May 2006 01:27:03 -0300 (ADT) Received: from governor (unverified [67.79.8.3]) by mail4.intermedia.net (Rockliffe SMTPRA 4.5.6) with ESMTP id ; Tue, 2 May 2006 21:27:03 -0700 From: "Gregory Stewart" To: "Jim C. Nasby" , "Mark Kirkwood" Cc: Subject: Re: Performance Issues on Opteron Dual Core Date: Tue, 2 May 2006 23:27:02 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869 In-Reply-To: <20060502202837.GC97354@pervasive.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/76 X-Sequence-Number: 18863 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