Streaming replication and high query cancellation values - Mailing list pgsql-general

From Christophe Pettus
Subject Streaming replication and high query cancellation values
Date
Msg-id 0A648BCB-BB75-447C-98E2-93C4AF50D008@thebuild.com
Whole thread Raw
Responses Re: Streaming replication and high query cancellation values  (Michael Nolan <htfoot@gmail.com>)
List pgsql-general
I have a couple of questions about how streaming replication works in the presence of a high timeout for query
cancellation:

1. Where is the WAL data stored while waiting for the query cancellation, the primary or the secondary?  In case of a
crashduring this interval, could the secondary end up behind the primary due to the WAL data not having been sent over? 

2. Can a very high query cancellation value run afoul of wal_keep_segments, or will the primary (assuming it's the one
doingthe storing) keep that data around until the query completes or is cancelled? 

Thanks!
--
-- Christophe Pettus
   xof@thebuild.com


pgsql-general by date:

Previous
From: dinesh kumar
Date:
Subject: Re: Threads With Libpq
Next
From: Condor
Date:
Subject: Need help with SQL query and finding NULL array_agg