Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Toc3D-0001uZ-8z for pgsql-admin@arkaria.postgresql.org; Fri, 28 Dec 2012 15:40:47 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1Toc3C-0006j6-Q1 for pgsql-admin@arkaria.postgresql.org; Fri, 28 Dec 2012 15:40:46 +0000 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TobzA-00064w-Df for pgsql-admin@postgresql.org; Fri, 28 Dec 2012 15:36:36 +0000 Received: from smtprelay0195.b.hostedemail.com ([64.98.42.195] helo=smtprelay.b.hostedemail.com) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tobz8-0000F7-St for pgsql-admin@postgresql.org; Fri, 28 Dec 2012 15:36:35 +0000 Received: from filter.hostedemail.com (b-bigip1 [10.5.19.254]) by smtprelay01.b.hostedemail.com (Postfix) with SMTP id 5C9791B99914 for ; Fri, 28 Dec 2012 15:36:33 +0000 (UTC) X-Panda: scanned! X-Spam-Summary: 10, 1, 0, , d41d8cd98f00b204, alvherre@alvh.no-ip.org, :pgsql-admin-owner@postgresql.org:odonnellm@usgs.gov, RULES_HIT:10:355:379:541:542:945:962:967:972:973:988:989:1042:1155:1189:1221:1256:1260:1261:1313:1314:1345:1436:1437:1516:1517:1518:1535:1542:1575:1587:1588:1589:1592:1594:1691:1711:1730:1777:1792:2194:2199:2379:2528:2559:2562:2691:2902:2917:3138:3139:3140:3141:3142:3353:3865:3866:3867:3868:3869:3870:3871:3872:3873:3874:4048:4120:4250:4321:4362:4379:5007:6119:6261:7688:7903:7974:8603:8634:8957:9108:9203:9868:10007:10026:10197:10400:10848:11656:11658:11914:12043:12220:12438:12517:12519:12521:12663, 0, RBL:none, CacheIP:none, Bayesian:0.5, 0.5, 0.5, Netcheck:none, DomainCache:0, MSF:not bulk, SPF:fn, MSBL:0, DNSBL:none, Custom_rules:0:1:0 X-Session-Marker: 616C76686572726540616C76682E6E6F2D69702E6F7267 X-Filterd-Recvd-Size: 9055 Received: from perhan.alvh.no-ip.org (unknown [190.95.16.219]) (Authenticated sender: alvherre@alvh.no-ip.org) by omf06.b.hostedemail.com (Postfix) with ESMTPA for ; Fri, 28 Dec 2012 15:36:31 +0000 (UTC) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id D69AF6E065; Fri, 28 Dec 2012 12:36:28 -0300 (CLST) Resent-From: Alvaro Herrera Resent-Date: Fri, 28 Dec 2012 12:36:28 -0300 Resent-Message-ID: <20121228153628.GA4150@alvh.no-ip.org> Resent-To: pgsql-admin@postgresql.org Received: from imap.noip.com (8.23.224.55:993) by localhost with IMAP4-SSL; 28 Dec 2012 14:45:42 -0000 X-FDA: 67039610232.06 X-Panda: scanned! X-Filterd-Recvd-Size: 8320 Received: from malur.postgresql.org (malur.postgresql.org [217.196.149.56]) by imf08.b.hostedemail.com (Postfix) with ESMTP for ; Fri, 28 Dec 2012 14:45:15 +0000 (UTC) Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TobBT-0005I3-3b for alvherre@alvh.no-ip.org; Fri, 28 Dec 2012 14:45:15 +0000 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TobBR-0005FC-M9 for pgsql-admin-owner@postgresql.org; Fri, 28 Dec 2012 14:45:13 +0000 Received: from smtp7.doi.gov ([137.227.28.13]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TobBO-0007vT-Hp for pgsql-admin-owner@postgresql.org; Fri, 28 Dec 2012 14:45:11 +0000 Received: from smtp8.smgr.doi.gov (10.10.28.14) by smtp7.doi.gov (10.10.28.23) with Microsoft SMTP Server (TLS) id 14.2.328.9; Fri, 28 Dec 2012 09:45:10 -0500 X-AuditID: 0a0a1c0e-b7f9f6d0000023b8-b3-50ddb07367c6 Received: from gsmtp6.doi.gov (Unknown_Domain [10.10.28.16]) (using TLS with cipher AES128-SHA (AES128-SHA/128 bits)) (Client did not present a certificate) by smtp8.smgr.doi.gov (Hello) with SMTP id 18.CC.09144.370BDD05; Fri, 28 Dec 2012 09:45:07 -0500 (EST) Received: from mail-ie0-f198.google.com (209.85.223.198) by gsmtp6.doi.gov (137.227.28.16) with Microsoft SMTP Server (TLS) id 14.2.247.3; Fri, 28 Dec 2012 09:45:01 -0500 Received: by mail-ie0-f198.google.com with SMTP id c10so45971512ieb.5 for ; Fri, 28 Dec 2012 06:45:06 -0800 (PST) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=x-received:from:mime-version:x-mailer:thread-index:date:message-id :subject:to:cc:content-type:x-gm-spam:x-gm-message-state; bh=1MkJTGeWA90wc0MMiK16ew42rdRPBogFcTB2sa+2ETQ=; b=T4WS4Y1hvU/FACxTUP8m1K8WNlPMl3zaGZoMffITTHlZB+VSoxRrqKQg6hcj2pkYBm Ea87vaEvMlvjOFoQwIoLBwJ553gBvE3pgsfxqke8RRlp6TX4tQBNkdJH6nB3BoETScMt iXqTF7JTYiGqp9jHbttKq7HECZLoRQhB5cj9rJCeI/UEkXxNV+Nv4XK6EyKAHbhqS5jW 8U9BT7j8yUrG6pr8OhK/mW7w8BYkyAuLeJGHNzM+lUjgQi/7Y3JPRUHRhohRb2jxD4Co /PzTmVVo4hX/2H5tOQ3HnHO+ZzpfSnH3U4ODALuCLWXWueBccqK+g33rFXywzQdkWzU8 bUmw== X-Received: by 10.50.190.163 with SMTP id gr3mr25097312igc.106.1356705906597; Fri, 28 Dec 2012 06:45:06 -0800 (PST) Received: by 10.50.190.163 with SMTP id gr3mr25097088igc.106.1356705902865; Fri, 28 Dec 2012 06:45:02 -0800 (PST) From: Michael O'Donnell MIME-Version: 1.0 X-Mailer: Microsoft Outlook 14.0 Thread-Index: Ac3lCVXXXNOUBa9YRO+Y0DwhhqmZ4A== Date: Fri, 28 Dec 2012 07:45:03 -0700 Message-ID: Subject: checksum error messages when using md5 To: CC: Content-Type: multipart/alternative; boundary="f46d0447881767ac1104d1eab580" X-Gm-Spam: 0 X-Gm-Message-State: ALoCoQn4GIl0Mxyop1m9WAO7HWgazTISFPUwf6imMcSocdE23hFbA7hKf0ikU3/kHyqElknst2iD8YJMKqstlh/Xzn2hS3YHozg6ziigUu7nXV2CVd/pryZles5tbx3wVDWrpRg8gQZ/acEt1uGEBFrPIKxAh41JNwbIaBzInyQMBXEgY9d0JWOJTHadsEPHIwInockG5Seze2jrMrNLEuHMizA85fwVA9nl2ERUBZV9FLY07oLQUi0= Received-SPF: SoftFail (gSMTP6.doi.gov: domain of transitioning odonnellm@usgs.gov discourages use of 209.85.223.198 as permitted sender) X-CFilter-Loop: Reflected X-Brightmail-Tracker: H4sIAAAAAAAAA+NgFprCIsWRmVeSWpSXmKPExsXCxfTjjW7xhrsBBn8uaFj0Hp/H7sDocWHf NPYAxigum5TUnMyy1CJ9uwSujJXvrQq+yVZsuvWPtYHxt0QXIyeHhICJxKeDu5kgbDGJC/fW s3UxcnEICXQySfxa2scM4axjlDjS+4YVpEpIYB6jxOEjBiAJCYETrBLnXv1ggWivkfj/dSIj RFGxxIbLp8DibAI6Eo+bZ7CD2LwCghInZz6BqleQ2HH2NVi9iICexORNl8BqWARUJU5u6oaq t5Vou3SCDcQWFtCX+D7pP9BFHED1ahLXN6eDhJkFJCQuXQQ5FMT2kdh19h4jxHgeiSlzL7JD 3NnDJHF+6WRGkF4hAXmJtlkREI91M0rsab4P9b6kxMEVN1gmMIrPQnLqLCRzIWw9iSlXW6Bs XYkL/6dA1WhLLFv4mnkBI+sqRqHi3JICC73i3PQivZT8TL30/LJNjKC44pLh28HY8dDiEKMA B6MSD++BFXcChFgTy4orcw8xSnAwK4nw9jXfDRDiTUmsrEotyo8vKs1JLT7EKM3BoiTOG6h0 O0BIID2xJDU7NbUgtQgmy8TBKdXAKFvfrf/3nLzwfdHUu4qPuTjP7Q8sDC1fKCnSbjYrek1A 9Iq3J+qDLp7gDExhf7hy/c6epm83BUXLd0e94v6bxhW+QLdkeearTOdZNUK1/Uf/BQuuzc6K e2v38emR2osshWrb3AOjLni9bGYQnrhG/okVf/et3McebDWHGGTkGY3bfN4e1nZQYinOSDTU Yi4qTgQA+V9zI6cCAAA= X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --f46d0447881767ac1104d1eab580 Content-Type: text/plain; charset="ISO-8859-1" I am using PG 9.0 on a Windows 2008 R2 server, and I have been seeing a lot of TCP connection errors in the log files. With Wireshark I was able to see two things. The first was checksum errors and the second was bad TCP connections, which I believe the latter is a result of the checksum errors. I have a Broadcom NetXtreme 57xx Gigabit Controller, which does not permit me to change the checksum offload configuration setting. Therefore, instead of using md5 in the pg_hba.conf file for authentication, I am now using password (not encrypted). When I made this change, I had no connection errors and the speed of the jobs increased by at least 4 fold. Would changing the NIC fix this problem or could there be a bug in the PG Windows software? Can anyone shed light on this topic for me and how I might best address the problem? I am not sure why I changing the md5 to password improved performance, but it might be simply because PG is not trying to resolve the problem. Is there some other piece I am missing that I need to consider. Thank you for your suggestions, Mike --f46d0447881767ac1104d1eab580 Content-Type: text/html; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable

I am using PG 9.0 on a Window= s 2008 R2 server, and I have been seeing a lot of TCP connection errors in = the log files. With Wireshark I was able to see two things. The first was c= hecksum errors and the second was bad TCP connections, which I believe the = latter is a result of the checksum errors. I have a Broadcom NetXtreme 57xx= Gigabit Controller, which does not permit me to change the checksum offloa= d configuration setting. Therefore, instead of using md5 in the pg_hba.conf= file for authentication, I am now using password (not encrypted). When I m= ade this change, I had no connection errors and the speed of the jobs incre= ased by at least 4 fold.

=A0

Would changing the NIC= fix this problem or could there be a bug in the PG Windows software? Can a= nyone shed light on this topic for me and how I might best address the prob= lem?

=A0

I am not sure why I ch= anging the md5 to password improved performance, but it might be simply bec= ause PG is not trying to resolve the problem. Is there some other piece I a= m missing that I need to consider.

=A0

Thank you for your sug= gestions,

Mike

=A0

<= /div> --f46d0447881767ac1104d1eab580--