Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 963279FB81B for ; Sat, 4 Aug 2007 17:36:12 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 62400-10 for ; Sat, 4 Aug 2007 17:35:56 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.phase.net.nz (ip-202-50-176-133.akl1.phase.net.nz [202.50.176.133]) by postgresql.org (Postfix) with ESMTP id 793539FB6B1 for ; Sat, 4 Aug 2007 17:35:59 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by mail.phase.net.nz (Postfix) with ESMTP id 9B75086C75 for ; Sun, 5 Aug 2007 08:35:54 +1200 (NZST) Received: from mail.phase.net.nz ([202.50.176.133]) by localhost (host01.akl1.phase.net.nz [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 15704-10 for ; Sun, 5 Aug 2007 08:35:49 +1200 (NZST) Received: from ASUSTED (tedjordan.clients.fishnet.net.nz [131.203.76.110]) by mail.phase.net.nz (Postfix) with ESMTP id A5EA486C6B for ; Sun, 5 Aug 2007 08:35:49 +1200 (NZST) From: "Ted Jordan" To: Subject: Default Performance between 8.0 and 8.1 Date: Sun, 5 Aug 2007 08:35:59 +1200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0006_01C7D73B.A70D56A0" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138 Thread-Index: AcfW1uy9U+MNZh/gQBaCKnzLw5eNcw== Message-Id: <20070804203549.A5EA486C6B@mail.phase.net.nz> X-Virus-Scanned: Debian amavisd-new at host01.akl1.phase.net.nz X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.102 tagged_above=0 required=5 tests=BAYES_50=0.001, HTML_MESSAGE=0.001, RDNS_DYNAMIC=0.1 X-Spam-Level: X-Archive-Number: 200708/32 X-Sequence-Number: 26162 This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C7D73B.A70D56A0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi We currently have some databases running under 8.0 and 8.1. I have noticed a significant difference in the time taken to restore dumps between the two versions, with 8.0 being much faster. For example a dump of a few MB will take just seconds to load under 8.0 but the same dump will take several minutes to load under 8.1. Currently we're just using the default parameter settings when installed via apt on Ubuntu Linux. I would just like to know if this is a well known issue and if there is a quick fix, or should I be digging deeper and seeing if the default settings are mismatched to certain linux kernel settings etc. Any help would be most appreciated. Thanks, Ted ------=_NextPart_000_0006_01C7D73B.A70D56A0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi

 

We currently have some databases = running under 8.0 and 8.1.  I have noticed a significant difference in the = time taken to restore dumps between the two versions, with 8.0 being much faster.  For example a dump of a few MB will take just seconds to = load under 8.0 but the same dump will take several minutes to load under = 8.1.  Currently we’re just using the default parameter settings when = installed via apt on Ubuntu Linux.

 

I would just like to know if this is = a well known issue and if there is a quick fix, or should I be digging deeper = and seeing if the default settings are mismatched to certain linux kernel = settings etc.

 

Any help would be most = appreciated.

 

Thanks,

Ted

------=_NextPart_000_0006_01C7D73B.A70D56A0--