Re: [GENERAL] Perfomance issue. statement in the log file..

Thank you. That will help us. We are changing the settings. We are running 9.0.4. Appreciate your time and help On Tue, Feb 23, 2016 at 3:20 PM, Roxanne Reid-Bennett wrote: > On 2/23/2016 11:57 AM, Bala Venkat wrote: > >> Dear All - >> >>We are seeing lot of the

[GENERAL] Perfomance issue. statement in the log file..

Dear All - We are seeing lot of these statements in the log file. We have 2 functions . Submit and update . Between submit and update which will int the process, the messages are appearning. The process is very slow. We don't know if this the main reason for the performance issue Can you

Re: [GENERAL] Replication Question

Thanks for the help. We need an upgrade on the DB for the solution. I checked your suggestion and it works on versions from 9.1 and above Regards On Thu, Jan 28, 2016 at 12:04 PM, Andreas Kretschmer < akretsch...@spamfence.net> wrote: > Bala Venkat wrote: > > > Hi there - >

[GENERAL] Replication Question

Hi there - We have a set up where there is One master streaming to 3 Slaves . 2 slaves are in our DR environment. One is the prod environment. Wanted to make the DR as primary. I know we can make the one of the slave in DR to primary. If I want to keep the other slave as sla

Re: [GENERAL] postgresql.conf question... CPU spikes

:43 AM, Bala Venkat wrote: > >> Hi all - >> >>We are running postgres 9.0 ( 32 bit ) + postgis 1.5.2 on Solaris >> Sparc M5000 with 64GB . Recently we are getting CPU utilitzation to 99% . >> >> In the config file >> >> >> share

[GENERAL] postgresql.conf question... CPU spikes

Hi all - We are running postgres 9.0 ( 32 bit ) + postgis 1.5.2 on Solaris Sparc M5000 with 64GB . Recently we are getting CPU utilitzation to 99% . In the config file shared_buffers=2GB. work_mem = 128MB effective_cache_size=48GB maintaince_work_mem= 500MB max_connections = 300 When t