0 byte files.
But , If i run the script in console , it creates the file with
content.
Any suggestion pls?
Regards
Bala
---(end of broadcast)---
TIP 6: explain analyze is your friend
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
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 -
>
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
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
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
: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
