The new Hot Standby feature in the upcoming PostgreSQL 9.0 allows running queries against standby nodes that previously did nothing but execute a recovery process. Two common expectations I’ve heard from users anticipating this feature is that it will allow either distributing short queries across both nodes, or allow running long reports against the standby […]
Trade-offs in Hot Standby Deployments
/0 Comments/in Greg's PlanetPostgreSQL, PostgreSQL /by 2ndQuadrant PressThe new Hot Standby feature in the upcoming PostgreSQL 9.0 allows running queries against standby nodes that previously did nothing but execute a recovery process. Two common expectations I’ve heard from users anticipating this feature is that it will allow either distributing short queries across both nodes, or allow running long reports against the standby […]
2ndQuadrant US Launch Party – February 12 New York City – Canceled
/0 Comments/in International News, United Kingdom News, United States News /by Gabriele BartoliniDue to the weather related travel issues this week, the launch party we had planned for this Friday has been canceled.
Measuring PostgreSQL Checkpoint Statistics
/1 Comment/in Greg's PlanetPostgreSQL, PostgreSQL /by 2ndQuadrant PressCheckpoints can be a major drag on write-heavy PostgreSQL installations. The first step toward identifying issues in this area is to monitor how often they happen, which just got an easier to use interface added to the database recently.
Hot Standby User Group (online) – 13 Jan at 1600UTC
/0 Comments/in International News, United Kingdom News, United States News /by Gabriele BartoliniCome on-line and discuss the features set of Hot Standby for PostgreSQL 8.5. Meeting is for anybody planning to actively use the Hot Standby in the next main release of PostgreSQL. Major focus is on providing user feedback direct to developers to guide the final weeks of development before we go into Beta.
2ndQuadrant Italia supports students affected by L’Aquila earthquakes
/0 Comments/in United Kingdom News /by Gabriele BartoliniAfter the earthquake that shook the city of L’Aquila and the entire Abruzzo region, 2ndQuadrant Italia is pleased to announce the signing of a collaborative agreement with the University of L’Aquila.