Tag Results

As we approach year end, our EDB team was inspired to take a look back at our blog posts from the year and see what topics resonated the most with our readers. Here is a Top 10 recap of your favorites from 2017. 10. Pgpool II Keeps Pace With Demands of Today’s Architectures and Workloads This blog is about Pgpool II, the middleware product that sits between the PostgreSQL server and database clients. Coming in at #10 for 2017, our readers […]

Streaming replication in PostgreSQL can be asynchronous or synchronous. The synchronous option provides greater data protection in case of disaster, or if a server or data center goes down. Synchronous replication does come with a performance penalty, which is why many people use the default asynchronous option if losing some data in case of disaster is not a big issue. For any application such as a financial application that cannot tolerate any data loss, synchronous replication is the answer. Synchronous replication […]