pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Joshua D. Drake <jd@commandprompt.com>
To: Gregory Stark <stark@enterprisedb.com>
Cc: Jonathan Ellis <jonathan@utahpython.org>
Cc: smiley2211 <smiley2211@yahoo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: How to ENABLE SQL capturing???
Date: Mon, 13 Aug 2007 09:15:35 -0700
Message-ID: <46C083A7.6000408@commandprompt.com> (raw)
In-Reply-To: <87vebjqv6m.fsf@oxford.xeocode.com>
References: <12060736.post@talk.nabble.com>
	<20070808203612.GA26143@uio.no>
	<bd8531800708081357i4f14b41axb0f19e444dc47a6e@mail.gmail.com>
	<12096180.post@talk.nabble.com>
	<Pine.LNX.4.64.0708101309230.1940@discord.home.frostconsultingllc.com>
	<12099590.post@talk.nabble.com>
	<46BCDDAA.3060703@commandprompt.com>
	<e06563880708130804i5f9277f1pe62e85c6c1e69df@mail.gmail.com>
	<46C07BFA.8000500@commandprompt.com>
	<87vebjqv6m.fsf@oxford.xeocode.com>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Gregory Stark wrote:
> "Joshua D. Drake" <jd@commandprompt.com> writes:
> 
>> If I recall correctly, it is because syslog is blocking.
> 
> Are you sure it isn't just that syslog fsyncs its log files after every log
> message?

Nope I am not sure at all ;). Darcy actually found the issue and can
speak better to it, I never use syslog and have always logged direct to
file.

 I don't think the individual syslogs are synchronous but if syslog
> falls behind the buffer will fill and throttle the sender.
> 
> If your Postgres data is on the same device as the syslogs those fsyncs will
> probably cause a big slowdown directly on Postgres's I/O as well.
> 
> You can turn off the fsyncs in syslog by putting a - before the filename.
> 


- --

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997  http://www.commandprompt.com/
			UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGwIOnATb/zqfZUUQRAqWqAKCEhoW/01Hc//cDEpREit8ipn2SZwCfUxPE
1Ir6eyuD4EcShwsn4sMAeKA=
=W2cJ
-----END PGP SIGNATURE-----



view thread (11+ messages)

Message-ID: <46C083A7.6000408@commandprompt.com>
Permalink:  ../46C083A7.6000408@commandprompt.com/
Also on:    postgresql.org/message-id/46C083A7.6000408@commandprompt.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: jd@commandprompt.com, stark@enterprisedb.com, jonathan@utahpython.org, smiley2211@yahoo.com
  Subject: Re: How to ENABLE SQL capturing???
  In-Reply-To: <46C083A7.6000408@commandprompt.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox