Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group