Hi,
Why is a citext column not using Btree index for like operation even without
any wildcard character? It can use Btree index if there is no wildcard
character and if it is at the end right?
Also a text column is using index when there is no wildcard character,but it
is also not using if it is pr
Hi,
What if we have a chain of slaves (master->slave->sec slave)? And if queries
would run on each of them? or a config like master ->slave1
->slave2
Is it ok to enable feedback on both slaves ?
--
View this message in context:
http://postgresql.nabble.com/Upd
Hi,
Thank you for the explanation.
The slave queries are mostly reporting queries,which sometimes would take
30+ running time due to complex joins and criteria. We haven't tried running
these queries on master before splitting, and it is possible that there will
be heavy updates and deletes on mast
Hi Jeff,
Yes I am turning off autovacuum for experimental purpose only. I was
curious to know what is causing the queries to be killed when the autovacuum
is not running. I guess it had to be the pruning of HOT update chains like
you have mentioned.
Also I have already tried changing the parameter
Hi,
I am using postgres 9.5
Yes,I restarted the server after changing the autovacuum to off. Also
verified that autovacuum process is not running.
standby db configurations: (mostly default conf only)
hot_standby = on
max_standby_archive_delay = 30s
max_standby_streaming_delay = 30s
wal_receiver_s
Hi,
I have the following configurations.
On master:
autovacuum=off
vacuum_defer_cleanup_age=0
On slave:
hot_standby_feedback = off
max_standby_streaming_delay = 30s
Now when I try to run a long query on slave and do some update or delete on
the table on master I am getting the following error.
