pgaudit and create postgis extension logs a lot inserts

Hi, I have installed pgaudit, and configured as: pgaudit.log = 'ddl,role' pgaudit.log_level = 'log' (default) Versions: postgresql96 (9.6.6) , pgaudit96 (1.0.4), postgis 2.3.2, Rhel 7.4 When I then install postgis extension in a database it writes a huge amount of logs which slow down the

need help on memory allocation

Hi Team, we are seeing idle sessions consuming memory in our database, could you please help me how much memory an idle session can use max and how can we find how much work_mem consuming for single process. we are getting out of memory error,for this i'm asking above questions. Regards,

Re: pgaudit and create postgis extension logs a lot inserts

On 01/18/2018 04:12 AM, Svensson Peter wrote: > When I then install  postgis extension in a database it writes a huge > amount of logs which slow down the server a lot. > Not only table creation and functions are logged,  even  all inserts in  > spatial_ref_sys are written to the audit-log. > >