Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id E00436502C7
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Wed, 27 Aug 2008 12:44:45 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 10363-03-7 for
	<pgsql-admin-postgresql.org@postgresql.org>;
	Wed, 27 Aug 2008 12:44:29 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from web25807.mail.ukl.yahoo.com (web25807.mail.ukl.yahoo.com
	[217.12.10.192]) by postgresql.org (Postfix) with SMTP id C89A96500FB
	for <pgsql-admin@postgresql.org>; Wed, 27 Aug 2008 12:42:28 -0300 (ADT)
Received: (qmail 75276 invoked by uid 60001); 27 Aug 2008 15:42:25 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.uk;
	h=X-YMail-OSG:Received:X-Mailer:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID;
	b=B0XNqjKrxDFMde7BIs8wRoG2vRnxMG5s0GASNrQ/euGTu0WxdadLsmX2WXiuTG7P8J6+9L96Ynb+S8wN2ih/BLWhkHxJLAtVE3u6EMcHGyMTpEl99O1TLlr+Zz8oI+MuWEJ3UDW7kQR7OkStISSAtwSqTQNQM+mr0kkmljYGJZk=;
X-YMail-OSG: 
 7ZqZjccVM1n0UM6bhuPvreHHqhNvTo2a8weOEwX4.f5UDmqv9nrpmWFcKqSLIObpcSFHwRI2qt16x4fnBdE4HVzuAd7WSz6vUgwCVblce2hBhQ.NKbFcPLs4ZrMFbO2SMOTWQ1OPGXS3fvOhdfvwIcbD
Received: from [62.254.183.162] by web25807.mail.ukl.yahoo.com via HTTP;
	Wed, 27 Aug 2008 15:42:25 GMT
X-Mailer: YahooMailWebService/0.7.218.2
Date: Wed, 27 Aug 2008 15:42:25 +0000 (GMT)
From: Valentin Bogdanov <valiouk@yahoo.co.uk>
Reply-To: valiouk@yahoo.co.uk
Subject: fsync off without a restart
To: pgsql-admin@postgresql.org
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Message-ID: <455333.74944.qm@web25807.mail.ukl.yahoo.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200808/198
X-Sequence-Number: 30043

Hi list,

I have got a script that is inserting, updating heavily at the moment. So, =
I want to turn fsync off to speed things up but I don't want to interrupt t=
he script.

If I do `postgresql reload` or `kill -HUP postmaster_pid` woudl that apply =
the fsync change? By the way, I have already tried it and seems that it has=
 worked.

But I have got another question. On my debian system I have got `postgresql=
 force-reload`. How does that differ from the plain reload? And what does i=
t actually do under the hood?

I am running Postgres 8.1.11 on Linux 2.6.18.

Regards,

Val=0A=0ASend instant messages to your online friends http://uk.messenger.y=
ahoo.com