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 451089DCAD3 for ; Wed, 30 Nov 2005 08:37:43 -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 14458-02 for ; Wed, 30 Nov 2005 08:37:44 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.206]) by postgresql.org (Postfix) with ESMTP id 5F9229DCBC4 for ; Wed, 30 Nov 2005 08:37:40 -0400 (AST) Received: by wproxy.gmail.com with SMTP id 69so83628wri for ; Wed, 30 Nov 2005 04:37:42 -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-priority:x-msmail-priority:x-mailer:importance:x-mimeole; b=L19YFDnsYN71RwBVaSTv/OFEHHI3eMuGAftk1yLKNnVvuWP2PWUmJTwNgIhm0gGPk4v6vnhQfcAkb/fddhG8mgiEWhyV0zOU7VZQq9MASWqFGDhrm6SOS5ZSNzI+pQLZP4zRxcEaTk38Q4CwJIAYwe2jBbtk/4t8AiTrgYbWXQ0= Received: by 10.54.62.18 with SMTP id k18mr463212wra; Wed, 30 Nov 2005 04:37:41 -0800 (PST) Received: from FRANKLIN ( [200.180.51.99]) by mx.gmail.com with ESMTP id 34sm254011wra.2005.11.30.04.37.40; Wed, 30 Nov 2005 04:37:41 -0800 (PST) From: "Franklin Haut" To: Subject: pg_dump slow Date: Wed, 30 Nov 2005 10:35:05 -0300 Message-ID: <000201c5f5b2$e0dc87a0$8500a8c0@FRANKLIN> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.4024 Importance: Normal 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: 200511/553 X-Sequence-Number: 15810 Hi=20 i=B4m using PostgreSQL on windows 2000, the pg_dump take around 50 = minutes to do backup of 200Mb data ( with no compression, and 15Mb with compression), but in windows XP does not pass of 40 seconds... :( This happens with 8.1 and version 8.0, somebody passed for the same situation?=20 It will be that a configuration in the priorities of the exists processes ? in Windows XP the processing of schemes goes 70% and constant accesses to the HardDisk, while that in windows 2000 it does not pass of 3%. thanks Franklin