2ndQuadrant Archives - Page 12 of 17 - 2ndQuadrant

Avoiding Disasters in New York

December 4, 2016/0 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon Riggs

What to do when disaster strikes… (various topics) King Kong attacks! Lure up tall building and attack with biplanes Godzilla’s eggs hatch Team up with European Special Forces operative to escape, then call in airstrike on Madison Square Gardens Watch the Rangers lose at home (same as above) Global Warming descends quickly Stay holed up […]

On the impact of full-page writes

November 23, 2016/20 Comments/in 2ndQuadrant, PostgreSQL, Tomas' PlanetPostgreSQL /by Tomas Vondra

While tweaking postgresql.conf, you might have noticed there’s an option called full_page_writes. The comment next to it says something about partial page writes, and people generally leave it set to on – which is a good thing, as I’ll explain later in this post. It’s however useful to understand what full page writes do, because […]

PostgreSQL Solution Architecture

November 8, 2016/0 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon Riggs

Keynote at PgConf.EU was well attended. I have already written about my impressions of the conference here. PostgreSQL is becoming a complete solution architecture for data, based upon the capabilities to push and pull data to/from other datastores, including other types of datastore. A variety of components, large and small make up that full architecture, […]

Highlights of PGconf.EU

November 4, 2016/0 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon Riggs

Wed 2 Nov Michiel Toneman from Adyen kicked things off with a keynote mentioning how Adyen have been using PostgreSQL for the past 9 years. I wasn’t aware Michiel was speaking, though I was very happy that he mentioned 2ndQuadrant’s extensive support of their multi-Terabyte PostgreSQL installations. http://www.postgresql.eu/events/schedule/pgconfeu2016/session/1419-building-a-unicorn-on-an-elephant/ I spent most of the first day […]

CHAR (16) – Another conference on the horizon but with a focus on business

November 2, 2016/0 Comments/in 2ndQuadrant, Featured, Howard Postgres Marketing World, Howard's PlanetPostgreSQL, United States News /by Umair Shahid

The PostgreSQL user community is becoming spoilt with a choice of excellent events organized by both local user groups and commercial organizations supporting the PostgreSQL project. And amongst the events taking place in December, the one you definitely shouldn’t miss attending is CHAR(16). ‘CHAR(16): Scalability for Business’ is intended to fulfill a different requirement – different […]

Back to the Future Part 3: pg_rewind with PostgreSQL 9.6

October 17, 2016/0 Comments/in 2ndQuadrant, Giuseppe's PlanetPostgreSQL /by 2ndQuadrant Press

This is the third and last part of blog articles dedicated to pg_rewind. In the two previous articles we have seen how pg_rewind is useful to fix split-brain events due to mistakes in the switchover procedures, avoiding the need of new base backups. We have also seen that this is true for simple replication clusters, where more standby nodes are involved.

Load data in Postgres-XL at over 9M rows/sec

October 13, 2016/6 Comments/in 2ndQuadrant, Pavan's PlanetPostgreSQL /by Pavan Deolasee

We are faced with this question: “What’s the ingestion rate of Postgres-XL?”, and I realised I don’t have a very good answer to that. Since recently we made some good improvements in this area, I was curious to know too. Well, I decided to benchmark. Hardware and Software For the tests, I used a Postgres-XL cluster running […]

Committed to the PostgreSQL Community, 2ndQuadrant Contributes to 9.6

September 29, 2016/3 Comments/in 2ndQuadrant, Featured, Umair's PlanetPostgreSQL /by Umair Shahid

The latest version of PostgreSQL 9.6 is planned to be released later today, bringing with it some much anticipated features and updates. As the most advanced open source database, PostgreSQL strives to release a major version roughly once every year. With an active and collaborative community, this PostgreSQL release boasts impressive features and updates thanks […]

The PostgreSQL 9.6 release is almost here!

September 28, 2016/3 Comments/in 2ndQuadrant, David's PlanetPostgreSQL /by David Rowley

The PostgreSQL 9.6 Release It feels like only just a few months ago that we were celebrating the release of PostgreSQL 9.5.0, but already we’re very close to the 9.6.0 release! For me personally, I’m very excited about this particular release of PostgreSQL. It was just 5 or 6 months ago that I was busy […]

Back to the Future Pt. 2: How to use pg_rewind with PostgreSQL 9.5

September 28, 2016/1 Comment/in 2ndQuadrant, Featured, Giuseppe's PlanetPostgreSQL /by 2ndQuadrant Press

In the previous blog article we have seen how pg_rewind works with a simple HA cluster, composed of a master node replicating to a standby. In this context, an eventual switchover involves just two nodes that have to be aligned. But what happens with HA clusters when there are several (also cascading) standbys? Now, consider […]

2ndQuadrant is now part of EDB