X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 0A02E9DC83B for ; Mon, 23 Jan 2006 05:46:19 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 04362-06 for ; Mon, 23 Jan 2006 05:46:19 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.199]) by postgresql.org (Postfix) with ESMTP id 3BDF59DC892 for ; Mon, 23 Jan 2006 05:46:16 -0400 (AST) Received: by wproxy.gmail.com with SMTP id 57so837228wri for ; Mon, 23 Jan 2006 01:46:16 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:from:to:subject:date:message-id:mime-version:content-type:content-transfer-encoding:x-mailer:thread-index:x-mimeole; b=sJxxlAwmRPd4t0Yot0TcdJySrovSL4zOONnAlRFHpeKcNnq+737tTEfaIDNVMdCjW36gmnd4TmJPBN228sFb7Kkqfs6GkQ2MgTcoWtCi8Q4mN52bhUcHcglnfjSkl5gJcFhIUvpv5gaKuZRN/8DIUy6rQWWL8BCErjZkjmlhd20= Received: by 10.54.93.20 with SMTP id q20mr5609024wrb; Mon, 23 Jan 2006 01:46:16 -0800 (PST) Received: from FRANKLIN ( [200.180.51.99]) by mx.gmail.com with ESMTP id 26sm1197494wrl.2006.01.23.01.46.15; Mon, 23 Jan 2006 01:46:16 -0800 (PST) From: "Franklin Haut" To: Subject: ENC: RES: pg_dump slow - Solution Date: Mon, 23 Jan 2006 07:46:27 -0300 Message-ID: <001701c6200a$44933e20$8500a8c0@FRANKLIN> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Office Outlook 11 Thread-Index: AcYekvM6kDjMLf+KSWODDQVoLXJ5qABdzLZg X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200601/408 X-Sequence-Number: 16886 Hi, Finally i found the problem of slow backup/restore, i=B4m only instaled = de Windows 2000 Service Pack 4... :) Thanks to all Franklin =20 -----Mensagem original----- De: Richard Huxton [mailto:dev@archonet.com] Enviada em: quarta-feira, = 30 de novembro de 2005 14:28 Para: Franklin Haut Cc: 'Ron'; pgsql-performance@postgresql.org Assunto: Re: RES: [PERFORM] pg_dump slow Franklin Haut wrote: > Hi, >=20 > Yes, my problem is that the pg_dump takes 40 secs to complete under=20 > WinXP and 50 minutes under W2K! The same database, the same hardware!, = > only diferrent Operational Systems. >=20 > The hardware is:=20 > Pentium4 HT 3.2 GHz > 1024 Mb Memory > HD 120Gb SATA There have been reports of very slow network performance on Win2k = systems with the default configuration. You'll have to check the archives for details I'm afraid. This might apply to you. If you're happy that doesn't affect you then I'd look at the disk system - perhaps XP has newer drivers than Win2k. What do the MS performance-charts show is happening? Specifically, CPU = and disk I/O. -- Richard Huxton Archonet Ltd