While running a
SELECT query (bit large query ~1GB of data output which took ~15minutes to execute) in hot standby replication host, its halts the wal archiving process. Once the Query done with the execution, the replication takes place and started replicating. Is that normal behaviour of postgres or need to tune system runtime configuration?
I have tried to change
work_mem=96MB, but still I couldn't solve the delay.
(using PG 9.5)