Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id C78DC9FB837 for ; Mon, 22 Oct 2007 14:54:52 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 08788-10 for ; Mon, 22 Oct 2007 14:54:43 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.autorevenue.com (ip-208.178.167.106.gblx.net [208.178.167.106]) by postgresql.org (Postfix) with ESMTP id 6A3BC9FB35C for ; Mon, 22 Oct 2007 14:54:44 -0300 (ADT) Received: (qmail 5697 invoked from network); 22 Oct 2007 13:57:14 -0400 Received: from unknown (HELO D1RPQZB1) (msteben@192.168.1.181) by mail.autorevenue.com with SMTP; 22 Oct 2007 13:57:14 -0400 From: "Mark Steben" To: Subject: bgwriter update question Date: Mon, 22 Oct 2007 13:52:30 -0400 Message-ID: <000901c814d4$51163010$b501a8c0@D1RPQZB1> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000A_01C814B2.CA049010" X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2992 thread-index: AcgU1FEHy9L5h481RgCRQZe4qW+Ejw== X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.085 tagged_above=0 required=5 tests=AWL=0.083, BAYES_50=0.001, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200710/211 X-Sequence-Number: 27125 This is a multi-part message in MIME format. ------=_NextPart_000_000A_01C814B2.CA049010 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit I'm running on 7.4.5 (pre bgwriter) and moving to 8.2 in 3 weeks. I turn fsync off on my testing server. When I update a table I expect the file in the base directory to remain the same size until the next syncpoint when it would then update. But it increases immediately. I thought updates remain in memory until syncpoint in pre-8.0. Am I missing somethng? Thanks for your time Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA 01238 413-243-4800 Home Office 413-243-4809 Corporate Fax msteben @autorevenue.com Visit our new website at www.autorevenue.com IMPORTANT: The information contained in this e-mail message is confidential and is intended only for the named addressee(s). If the reader of this e-mail message is not the intended recipient (or the individual responsible for the delivery of this e-mail message to the intended recipient), please be advised that any re-use, dissemination, distribution or copying of this e-mail message is prohibited. If you have received this e-mail message in error, please reply to the sender that you have received this e-mail message in error and then delete it. Thank you. ------=_NextPart_000_000A_01C814B2.CA049010 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I'm running on 7.4.5 (pre bgwriter) and moving to = 8.2 in 3 weeks. I turn fsync off on my testing server. When I = update a table I expect the file in the base directory to remain = the same size until the next syncpoint when it would then = update. But it increases immediately. I thought updates remain in = memory until syncpoint in pre-8.0. Am I missing = somethng?

 

Thanks for your time

 

Mark Steben

Senior Database Administrator
@utoRevenue™
A Dominion = Enterprises Company
480 = Pleasant Street
Suite = B200
Lee, MA 01238
413-243-4800 Home Office 
413-243-4809 Corporate Fax

msteben@autorevenue.com

Visit our = new website at
www.autorevenue.com

 

IMPORTANT: The information = contained in this e-mail message is confidential and is intended only for the named addressee(s). If the reader of this e-mail message is not the intended recipient (or the individual responsible for the delivery of this e-mail = message to the intended recipient), please be advised that any re-use, = dissemination, distribution or copying of this e-mail message is prohibited.  If = you have received this e-mail message in error, please reply to the sender that = you have received this e-mail message in error and then delete it.  Thank = you.

 

------=_NextPart_000_000A_01C814B2.CA049010--