Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I used this guide to make replication between my two db servers : http://wiki.postgresql.org/wiki/Streaming_Replication

But, when I updated a row on master server it will be available in slave instantly. It should be asynchronous , isn't it? What I am missing?

Thank You

share|improve this question

migrated from stackoverflow.com Apr 1 '13 at 0:05

This question came from our site for professional and enthusiast programmers.

    
Are you trying to say that currently, replication is slow? I don't really get what the question is. –  thejh Mar 31 '13 at 20:33
    
No, on the contrary it's very fast. –  ecabuk Mar 31 '13 at 20:36
add comment

1 Answer 1

up vote 3 down vote accepted

Async and Slow are not the same thing. If you start putting real load on the replication stream, you will start to see delays, but not with a single test command.

share|improve this answer
    
servers are in separate places and master's upload speed is ~75kb/sec –  ecabuk Mar 31 '13 at 20:37
    
@ecabuk And how big were the records you inserted? When you're just sending fifty bytes or so from time to time, your upload bandwidth doesn't matter. –  thejh Mar 31 '13 at 20:42
    
sorry for previous comment, I pressed the enter by mistake. servers are in separate places and master's upload speed is ~75kb/sec. As far as i know, first of all, 16mb xlog file should be upload to slave, after that transections available on slave. But it will happening in 1 sec. –  ecabuk Mar 31 '13 at 20:45
1  
Quote: 'In SR, XLOG records in partially-filled XLOG file are shipped too, implementing record-based log-shipping.' - so streaming replication is exactly that: The stream of updates is transported from master to slave. –  Eugen Rieck Mar 31 '13 at 20:50
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.