Re: SV: pgaudit and create postgis extension logs a lot inserts

2018-01-30 Thread Bruce Momjian
On Fri, Jan 19, 2018 at 11:03:42AM +, Svensson Peter wrote: > > A test to create postgis extension made 4 rsyslog processes run for several > minutes with high cpu util, > and when you have only 8 cpu:s this take lot of resources. > The create command also have to wait until all the log are

SV: pgaudit and create postgis extension logs a lot inserts

2018-01-22 Thread Svensson Peter
OK, thanks a lot. Regards, Peter Från: David Steele [da...@pgmasters.net] Skickat: den 19 januari 2018 14:41 Till: Magnus Hagander; Joe Conway Kopia: Svensson Peter; pgsql-performa...@postgresql.org Ämne: Re: pgaudit and create postgis extension logs a

SV: pgaudit and create postgis extension logs a lot inserts

2018-01-19 Thread Svensson Peter
A test to create postgis extension made 4 rsyslog processes run for several minutes with high cpu util, and when you have only 8 cpu:s this take lot of resources. The create command also have to wait until all the log are written so there are great impact. Log file got 16 GB big only for this.