Re: syslog performance when logging big statements

From: "achill(at)matrix" <achill(at)matrix(dot)gatewaynet(dot)com>
To: david(at)lang(dot)hm
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Jeff <threshar(at)threshar(dot)is-a-geek(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: syslog performance when logging big statements
Date: 2008-07-09 12:51:30
Message-ID: 200807091551.31404.achill@matrix.gatewaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


>In FreeBSD 7.0 by default it does not fsync (except for kernel messages),
>unless the path is prefixed by "-" whereas it syncs.
Sorry, scrap the above sentence.
The correct is to say that FreeBSD 7.0 by default it does not fsync(2) (except
for kernel messages), and even in this case of kernel messages, syncing
can be bypassed by the use of "-" prefix.
So in our case of postgresql (local0 facility) it does not sync.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Vivek Khera 2008-07-09 15:59:31 Re: max fsm pages question
Previous Message achill@matrix 2008-07-09 12:37:26 Re: syslog performance when logging big statements