Re: need help on memory allocation

Rambabu V wrote: > 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 quest

SV: pgaudit and create postgis extension logs a lot inserts

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.

Re: pgaudit and create postgis extension logs a lot inserts

On Thu, Jan 18, 2018 at 6:54 PM, Joe Conway wrote: > 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 insert

RE: pgaudit and create postgis extension logs a lot inserts

Please remove me from this list. Thanks. Karen Stone| Technical Services| Eldorado |a Division of MphasiS 5353 North 16th Street, Suite 400, Phoenix, Arizona 85016-3228 Tel (928) 892 5735 | www.eldoinc.com | www.mphasis.com |kst...@eldocomp.com -Original Message- From: Svensson Peter

Re: pgaudit and create postgis extension logs a lot inserts

On 1/19/18 6:05 AM, Magnus Hagander wrote: > > > On Thu, Jan 18, 2018 at 6:54 PM, Joe Conway > wrote: > > 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

Re: pgaudit and create postgis extension logs a lot inserts

Hi Peter, On 1/18/18 7:12 AM, Svensson Peter wrote: > > Also noticed that setting a session log to none (set > pgaudit.log='none';)  overrides parameter from postgresql.conf,  but > does not get logged, and then you can do whatever you want without any > audit. > I supposed this changing of  audi

Performance impact of lowering max_files_per_process

We have a customer project where Postgres is using too many file handles during peak times (around 150.000) Apart from re-configuring the operating system (CentOS) this could also be mitigated by lowering max_files_per_process. I wonder what performance implications that has on a server with a