Re: Hot Standby query cancellation and Streaming Replication integration - Mailing list pgsql-hackers

From Greg Stark
Subject Re: Hot Standby query cancellation and Streaming Replication integration
Date
Msg-id 407d949e1002261311y25ab9384u8c3cf70c1daae082@mail.gmail.com
Whole thread Raw
In response to Re: Hot Standby query cancellation and Streaming Replication integration  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Hot Standby query cancellation and Streaming Replication integration  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Fri, Feb 26, 2010 at 8:30 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> How's it going to do that, when it has no queries at the instant
> of startup?
>

Why shouldn't it have any queries at walreceiver startup? It has any
xlog segments that were copied from the master and any it can find in
the archive, it could easily reach a consistent point long before it
needs to connect to the master. If you really want to protect your
master from any additional overhead you don't currently need to
configure a streaming connection at all, you can just use the file
shipping interface.

-- 
greg


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Hot Standby query cancellation and Streaming Replication integration
Next
From: Tom Lane
Date:
Subject: Re: Hot Standby query cancellation and Streaming Replication integration