want to tamper the system
catalogs in any manner. Is there a solution for this?
PostgreSQL 10 and barman 2.4 on rhel 7 is my environment.
Thanks, Rijo Roy
Sent from Yahoo Mail on Android
Yes Ian, it worked..
Many Thanks,Rijo Roy
On Friday, 21 December, 2018, 4:16:09 AM IST, Ian Lawrence Barwick
wrote:
2018年12月20日(木) 21:58 Rijo Roy :
>
> Thanks sk for replying Ian.. I have one inactive replication slot in the
> database. I suspected that could be the cause bu
wal_keep_segments is set to 0. Appreciate your help!
Thanks,
Rijo Roy
Sent from Yahoo Mail on Android
Thanks Adrian for sharing the facts and docs..
Is there a possibility to disable auto analyze if we set
autovacuum_analyze_scale_factor to 100% and autovacuum_analyze_threshold = 0?
Thanks, Rijo Roy
Sent from Yahoo Mail on Android
On Mon, 15 Oct 2018 at 6:48 pm, Adrian Klaver
wrote: On
Yeah when age(relfrozenxid) goes beyond the limit Postgresql will invoke the
autovacuum session to avoid a wraparound issue.. But here that's not the case..
Sent from Yahoo Mail on Android
On Mon, 15 Oct 2018 at 2:58 pm, Arthur Zakirov
wrote: On 10/15/18 11:01 AM, Rijo Roy
tting autovacuum = on except for
Template0 database. What is your opinion?
Thanks, Rijo Roy
Sent from Yahoo Mail on Android
Hello Experts,
I have a server rhel 6.9 installed with barman 2.3 which is configured to take
backup from Postgresql 10 installed in a remote host and the same is working.
I am trying to do a poc on streaming backup and streaming wal method by making
use of the pg_receivewal. I have already creat
I agree.. But unfortunately it is the business call and we cannot alter it.. I
am planning to convince them by keeping autovacuum_analyze_threshold to a high
value so that auto analyse will not kick in very often leaving the autovacuum
to do its job.. Please advise.
Thanks, Rijo Roy
Sent from
hanks, Rijo Roy
Sent from Yahoo Mail on Android
On Wed, 1 Aug 2018 at 7:38 pm, Tom Lane wrote: Rijo Roy
writes:
> I am observing a steady increase in age(datfrozenxid) of template0 database
> in my Postgresql 10 running in a RHEL 6.9Currently, it is at 166846989 and I
> am not
same. Before doing that, I wanted to
check whether I should be worrying for something here or can I just go ahead
with my plan.
Thanks, Rijo Roy
Sent from Yahoo Mail on Android
server.
2. Is there any other mechanism to track the restoration process other than to
check the postgresql logs.
The postgresql version used in 10.0 on a Linux 6.9
Thanks, Rijo Roy
Sent from Yahoo Mail on Android
Thanks a lot Steve, that really answers my question..
Many thanks, Rijo Roy
Sent from Yahoo Mail on Android
On Wed, 11 Jul 2018 at 7:50 pm, Steven
Winfield wrote: #yiv8600935552
#yiv8600935552 -- _filtered #yiv8600935552 {panose-1:2 2 6 9 4 2 5 8 3 4;}
_filtered #yiv8600935552 {panose
table_name (to prevent
wraparound). I have initiated a normal vacuum manually but it is stuck on the
table where the autovacuum is processing it.
Thanks, Rijo Roy
Sent from Yahoo Mail on Android
On Wed, 11 Jul 2018 at 7:30 pm, Steven
Winfield wrote: #yiv7029743585
#yiv7029743585 -- _filtered
table? If yes, that
causes lock waits.
=== Original Message===
On Jul 11, 2018, at 08:13 , Rijo Roy wrote:
Hi Ravi,
It was the application teams call to disable it fearing the alteration of
execution plans and slowness as per their explanation. I have joined 2
+pgsql-general
Sent from Yahoo Mail on Android
On Wed, 11 Jul 2018 at 5:43 pm, Rijo Roy wrote: Hi Ravi,
It was the application teams call to disable it fearing the alteration of
execution plans and slowness as per their explanation. I have joined 2 days
back and I have tried educating
tables have TB'S of
data.Experts, please confirm whether I can kill these sessions and run a manual
vacuum job with parallel jobs.
Thanks in advance.
Regards, Rijo Roy
Sent from Yahoo Mail on Android
16 matches
Mail list logo