Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 53F63633E43 for ; Thu, 20 May 2010 13:55:08 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 38553-10 for ; Thu, 20 May 2010 16:55:01 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from bay0-omc1-s14.bay0.hotmail.com (bay0-omc1-s14.bay0.hotmail.com [65.54.190.25]) by mail.postgresql.org (Postfix) with ESMTP id 8DA4D632FDC for ; Thu, 20 May 2010 13:55:00 -0300 (ADT) Received: from BAY149-W31 ([65.54.190.61]) by bay0-omc1-s14.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.4675); Thu, 20 May 2010 09:54:56 -0700 Message-ID: Content-Type: multipart/alternative; boundary="_39c10c80-ad94-4ad4-b2cd-72cf5ee54f31_" X-Originating-IP: [129.44.63.215] From: Balkrishna Sharma To: Subject: Asynchronous commit | Transaction loss at server crash Date: Thu, 20 May 2010 12:54:56 -0400 Importance: Normal MIME-Version: 1.0 X-OriginalArrivalTime: 20 May 2010 16:54:56.0839 (UTC) FILETIME=[2D317570:01CAF83D] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.909 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201005/191 X-Sequence-Number: 34664 --_39c10c80-ad94-4ad4-b2cd-72cf5ee54f31_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello=2CCouple of questions:1. For the 'Asynchronous commit' mode=2C I know= that WAL transactions not flushed to permanent storage will be lost in ev= ent of a server crash. Is it possible to know what were the non-flushed tra= nsactions that were lost=2C in any shape/form/part ? I guess not=2C but wan= ted to confirm. 2. If above is true=2C then for my application 'Asynchronous commit' is not= an option. In that case=2C how is it possible to increase the speed of 'Sy= nchronous Commit' ? Can a SDD rather than HDD make a difference ? Can throw= ing RAM have an impact ? Is there some test somewhere of how much RAM will = help to beef up the write process (for synch commit). I need to support several hundreds of concurrent update/inserts from an onl= ine form with pretty low latency (maybe couple of milliseconds at max). Thi= nk of a save to database at every 'tab-out' in an online form. Thanks=2C-Bala =20 _________________________________________________________________ The New Busy is not the old busy. Search=2C chat and e-mail from your inbox= . http://www.windowslive.com/campaign/thenewbusy?ocid=3DPID28326::T:WLMTAGL:O= N:WL:en-US:WM_HMP:042010_3= --_39c10c80-ad94-4ad4-b2cd-72cf5ee54f31_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello=2C
Couple of questions:
1. For the 'Asynchro= nous commit' mode=2C I know that WAL transactions not flushed to permanent = storage will be  =3Blost in event of a server crash. Is it possible to = know what were the non-flushed transactions that were lost=2C in any shape/= form/part ? I guess not=2C but wanted to confirm.

=
2. If above is true=2C then for my application 'Asynchronous commit' i= s not an option. In that case=2C how is it possible to increase the speed o= f 'Synchronous Commit' ? Can a SDD rather than HDD make a difference ? Can = throwing RAM have an impact ? Is there some test somewhere of how much RAM = will help to beef up the write process (for synch commit).

I need to support several hundreds of concurrent update/inserts fr= om an online form with pretty low latency (maybe couple of milliseconds at = max). Think of a save to database at every 'tab-out' in an online form.

Thanks=2C
-Bala

=

The New Busy is not the old busy. Search=2C chat and= e-mail from your inbox. Get started. = --_39c10c80-ad94-4ad4-b2cd-72cf5ee54f31_--