Streaming replication and high query cancellation values

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: pgsql-general list <pgsql-general(at)postgresql(dot)org>
Subject: Streaming replication and high query cancellation values
Date: 2012-08-01 20:03:42
Message-ID: 0A648BCB-BB75-447C-98E2-93C4AF50D008@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 crash during 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 doing the storing) keep that data around until the query completes or is cancelled?

Thanks!
--
-- Christophe Pettus
xof(at)thebuild(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Condor 2012-08-01 20:16:06 Need help with SQL query and finding NULL array_agg
Previous Message dinesh kumar 2012-08-01 15:04:34 Re: Threads With Libpq