Posts
Barman 2.1 and the new –archive option
/0 Comments/in Giulio's PlanetPostgreSQL /by Giulio CalacociBarman 2.1 Version 2.1 of Barman, backup and recovery manager for PostgreSQL, was released Thursday, Jan. 5. The new release, along with several bugfixes, introduces preliminary support for the upcoming PostgreSQL 10, and adds the –archive option to the switch-xlog command. switch-xlog –archive The new –archive option is especially useful when setting up a new […]
PGDay.IT 2016 in Prato, Italy
/0 Comments/in 2ndQuadrant, Jonathan's PlanetPostgreSQL /by Jonathan BattiatoThis year, the ITPUG (Italian Postgres User Group) organized PGDay in Prato, my hometown and city where the association was born, although most of the members are from outside of the Tuscany region. It was my pleasure to contribute to the community by sharing my professional experience. I gave a talk about PostgreSQL on Network File System, […]
The PostgreSQL License – What Does It Mean For My Business?
/7 Comments/in Umair's PlanetPostgreSQL /by Umair ShahidWhen I talk to various people about PostgreSQL, based on where they are in the process of analyzing it, I get asked many similar questions. One of the most frequently asked questions is: What is the PostgreSQL licensing model? Here is my attempt to address this question from the perspective of what the PostgreSQL license […]
On the impact of full-page writes
/20 Comments/in 2ndQuadrant, PostgreSQL, Tomas' PlanetPostgreSQL /by Tomas VondraWhile 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 Meetup in Melbourne, Australia
/0 Comments/in Gabriele's PlanetPostgreSQL /by Gabriele BartoliniIf you live in the Melbourne area and you are passionate about PostgreSQL then don’t miss the chance to come to the Melbourne PostgreSQL Users Group Meetup this Monday, 21 November.
Postgres-XL Scalability for Loading Data
/2 Comments/in Pavan's PlanetPostgreSQL /by Pavan DeolaseeIn my last blog, we looked at the benchmark results from bulk load test for a Postgres-XL database cluster. Using a 16-datanode, 2-coordinator cluster, running on EC2 instances, we could easily clock 9M rows/sec or 3TB/hr of ingestion rate. That’s a significant number in itself. In this blog, we’ll see if the ingestion rate is […]
Back to the Future Part 3: pg_rewind with PostgreSQL 9.6
/0 Comments/in 2ndQuadrant, Giuseppe's PlanetPostgreSQL /by 2ndQuadrant PressThis 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
/6 Comments/in 2ndQuadrant, Pavan's PlanetPostgreSQL /by Pavan DeolaseeWe 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 […]
More ‘POWER’ for PostgreSQL
/0 Comments/in Featured, Gabriele's PlanetPostgreSQL /by Gabriele BartoliniNow Available! Debian and Ubuntu packages for Power Architecture. The official announcement was published last Friday, September 30, 2016: the PostgreSQL repository for Debian and Ubuntu packages, apt.postgresql.org, has been extended by adding binary packages of IBM’s Little Endian POWER8 architecture.