Re: Understanding PG9.0 streaming replication feature

Directly moving WAL records from one database server to another is typically described as log shipping. PostgreSQL implements file-based log shipping, which means that WAL records are transferred one file (WAL segment) at a time. WAL files (16MB) can be shipped easily and cheaply over any distance, whether it be to an adjacent system, another system at the same site, or another system on the far side of the globe. The bandwidth required for this technique varies according to the transaction rate of the primary server. Record-based log shipping is also possible with streaming replication (see Section 25.2.5).

It should be noted that the log shipping is asynchronous, i.e., the WAL records are shipped after transaction commit. As a result, there is a window for data loss should the primary server suffer a catastrophic failure; transactions not yet shipped will be lost. The size of the data loss window in file-based log shipping can be limited by use of the archive_timeout parameter, which can be set as low as a few seconds. However such a low setting will substantially increase the bandwidth required for file shipping. If you need a window of less than a minute or so, consider using streaming replication (see Section 25.2.5).

I colored things that apply to both in purple, that apply just to file-based log shipping in red, and that just apply to streaming replication in green.  So if you are reading through this for the first time looking for information on streaming replication, it is very difficult to figure out some key points (it works by log-shipping, it is asynchronous), while avoiding stuff that you don't need to worry about (archive_timeout, WAL files are transferred one at a time, etc).

I doubt I am the first person that is using postgres replication for the first time because of hot standbys and streaming replication, and I think the document is very poor for dealing with those people.  Just looking at the coloring above, it looks very clearly like the document was written for file-based log shipping and then details about streaming replication are just appended at the end.

The great thing about the wiki page (which I am assuming is the doc OP is referring to positively) is that it only includes details about streaming replication, thus you don't have to constantly be dodging information that doesn't apply to you.