I’m extremely pleased to see that after months of efforts and contributions by different people around the world, Postgres-XL 9.5 R1 Beta1 has finally arrived. This release is significantly better, in all respects such as performance, stability and high availability, as compared to the past release. Enormous amount of work has gone into PostgreSQL in the […]
Postgres-XL 9.5R1Beta1 is here!
/1 Comment/in 2ndQuadrant, Pavan's PlanetPostgreSQL /by Pavan DeolaseeI’m extremely pleased to see that after months of efforts and contributions by different people around the world, Postgres-XL 9.5 R1 Beta1 has finally arrived. This release is significantly better, in all respects such as performance, stability and high availability, as compared to the past release. Enormous amount of work has gone into PostgreSQL in the […]
Looking forward to PGDay India 2016
/1 Comment/in Pavan's PlanetPostgreSQL /by Pavan DeolaseeWith just couple of weeks to go for PGDay India, I’m quite excited about the upcoming PostgreSQL conference at Bangalore on 26th February, 2016. This is going to be the biggest ever conglomeration of users, developers and companies interested in PostgreSQL in India. This is also by far the largest PostgreSQL conference in terms of number […]
Postgres-XL: Dealing with read-only transactions
/3 Comments/in 2ndQuadrant, Pavan's PlanetPostgreSQL /by Pavan DeolaseeOne of the problems with Postgres-XL 9.2 is that it assigns a global transaction identifier (GXID) for every transaction that is started in the cluster. Since its hard for the system to know if a transaction is read-only or not (remember, even SELECT queries can do write activities), Postgres-XL would always assign a GXID and send […]
2ndQ talks at PGDay FOSDEM 2016
/0 Comments/in Umair's PlanetPostgreSQL /by Umair ShahidIt is always exciting to meet community members and exchange ideas about PostgreSQL and the eco-system around the database. I was lucky enough to be a part of FOSDEM PGDay in Brussels on 29th January this year. 3 of 2ndQuadrant’s very best spoke at the event. If you missed the talks, you can take a […]
Prague PostgreSQL Developer Day 2016
/0 Comments/in 2ndQuadrant, Gulcin's PlanetPostgreSQL, PostgreSQL /by Gulcin YildirimThe 9th annual “Prague PostgreSQL Developer Day” conference will be held on 17th and 18th February in Prague.
PgBouncer 1.7 – “Colors Vary After Resurrection”
/7 Comments/in 2ndQuadrant, Gulcin's PlanetPostgreSQL, PostgreSQL /by Gulcin YildirimPgBouncer is a lightweight connection pooler for PostgreSQL. PgBouncer 1.7 was announced on the 18th of December 2015. In this blog post we’ll talk about the major new improvements in PgBouncer.
PostgreSQL Planet in Ansible Galaxy
/0 Comments/in 2ndQuadrant, Gulcin's PlanetPostgreSQL, PostgreSQL /by Gulcin YildirimAnsible Galaxy is simply the easiest way of finding already written Ansible roles, creating and sharing your roles and jump into the galaxy of Ansible content!
SCALE 14x
/2 Comments/in Mark's PlanetPostgreSQL /by Mark WongI had the pleasure of speaking about PostgreSQL performance at The 14th Annual Southern California Linux Expo and meeting many enthusiastic database users in the expo hall. There was a great turnout of people attending the conference, and many PostgreSQL presentations to see. Simon Riggs also talked about SERIALIZABLE, Eventual Consistency and Really Scary Stuff. […]
Postgres-XL 9.5: Gearing Towards the Beta Release
/6 Comments/in Umair's PlanetPostgreSQL /by Umair ShahidPostgreSQL has typically been described as an OLTP-friendly database and has generally been put to the side for OLAP workloads. While I disagree with this notion to begin with, the new Big Data features of the latest 9.5 release makes such thinking even more obsolete. This is also why I am so excited about the […]
Performance limits of logical replication solutions
/6 Comments/in 2ndQuadrant, pglogical, PostgreSQL, Tomas' PlanetPostgreSQL /by Tomas VondraIn the previous blog post, I briefly explained how we got the performance numbers published in the pglogical announcement. In this blog post I’d like to discuss the performance limits of logical replication solutions in general, and also how they apply to pglogical. physical replication Firstly, let’s see how physical replication (built into PostgreSQL since […]