Re: [PERFORM] max fsm pages question

2008-07-09 Thread Vivek Khera
On Jul 8, 2008, at 3:24 PM, Bill Moran wrote: If you don't handle this, that table will continue to grow in size on the disk, taking up space unnecessarily and probably negatively impacting performance. s/probably/definitely/ Also, if it was #3 on Bill's list, one thing to do is look for ind

Re: [PERFORM] syslog performance when logging big statements

2008-07-09 Thread [EMAIL PROTECTED]
Στις Tuesday 08 July 2008 21:34:01 ο/η Tom Lane έγραψε: > Achilleas Mantzios <[EMAIL PROTECTED]> writes: > > Στις Tuesday 08 July 2008 17:35:16 ο/η Tom Lane έγραψε: > >> Hmm. There's a function in elog.c that breaks log messages into chunks > >> for syslog. I don't think anyone's ever looked hard

Re: [PERFORM] syslog performance when logging big statements

2008-07-09 Thread [EMAIL PROTECTED]
>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 me

Re: [PERFORM] syslog performance when logging big statements

2008-07-09 Thread [EMAIL PROTECTED]
Στις Wednesday 09 July 2008 03:47:34 ο/η [EMAIL PROTECTED] έγραψε: > On Tue, 8 Jul 2008, Tom Lane wrote: > > Jeff <[EMAIL PROTECTED]> writes: > >> On Jul 8, 2008, at 8:24 AM, Achilleas Mantzios wrote: > >>> File sizes of about 3M result in actual logging output of ~ 10Mb. > >>> In this case, the IN