Great conference! Paris is a great venue for travellers across Europe and worldwide. PgDay Paris 2017 was held in English and attracted a wide audience from many other countries: UK, NL, CH, BE, US, SE – and that was just the people I spoke to. Je suis desolee ne parler ou ecrit pas en francais. […]
2ndQuadrant – Not the Gartner Magic Quadrant
/0 Comments/in 2ndQuadrant /by Umair ShahidIt’s still appropriate though. Because that is what we are – thought leaders in open source PostgreSQL. But that’s not what I am here to talk about. The name “2ndQuadrant” comes from “The Seven Habits of Highly Effective People” by Stephen Covey, specifically Habit 3 “Put First Things First”, p.151. It refers to the classification […]
PgDay Paris 2017
/0 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon RiggsGreat conference! Paris is a great venue for travellers across Europe and worldwide. PgDay Paris 2017 was held in English and attracted a wide audience from many other countries: UK, NL, CH, BE, US, SE – and that was just the people I spoke to. Je suis desolee ne parler ou ecrit pas en francais. […]
PGConf India 2017 – An Event to Remember
/0 Comments/in 2ndQuadrant, Pavan's PlanetPostgreSQL /by Pavan DeolaseeYet another edition of PGConf India came to conclusion in early March. You may have noticed the change from PGDay to PGConf, which signals a much larger gathering of PostgreSQL enthusiasts, now and in future. What started as a small meet-up of like minded people 4 years back, has now grown into a 2-day conference […]
Re-import repository keys for BDR and pglogical apt repositories
/2 Comments/in Craig's PlanetPostgreSQL /by craig.ringerThe BDR and pglogical apt repository GnuPG signing keys have been renewed. Users should re-import the existing keys. You can verify that it’s still the same key as referenced in the documentation, just with a later expiry date. Simply run: wget –quiet -O – http://packages.2ndquadrant.com/bdr/apt/AA7A6805.asc | sudo apt-key add – sudo apt-key finger AA7A6805 | […]
Support for enums in btree_gin and btree_gist
/3 Comments/in Andrew's PlanetPostgreSQL /by Andrew DunstanI have just committed a series of patches that provide support for enum types in the btree_gin and btree_gist standard extensions. This is something I first started work on about a year ago. It turned out to be more involved that I had first thought it would be, as it requires some additional core code […]
JSON version of XMLTABLE example
/5 Comments/in Andrew's PlanetPostgreSQL /by Andrew DunstanMy colleague Álvaro Herrera gave a terrific explanation of the new XMLTABLE feature from Pavel Stěhule that he’s put a huge amount of effort into, and finally recently committed. I thought it would be fun to see how the example he gave might work today with JSON. First, I came up with a JSON equivalent […]
XMLTABLE in PostgreSQL
/14 Comments/in Alvaro's PlanetPostgreSQL, PostgreSQL /by Álvaro HerreraI just committed a patch by Pavel Stěhule that adds the XMLTABLE functionality to PostgreSQL 10. XMLTABLE is a very useful feature dictated by the SQL/XML standard, that lets you turn your XML data into relational form, so that you can mix it with the rest of your relational data. This feature has many uses; keep reading for […]
Benchmark on a Parallel Processing Monster!
/8 Comments/in David's PlanetPostgreSQL /by David RowleyLast year I wrote about a benchmark which I performed on the Parallel Aggregate feature that I worked on for PostgreSQL 9.6. I was pretty excited to see this code finally ship in September last year, however something stood out on the release announcement that I didn’t quite understand: Scale Up with Parallel Query Version 9.6 […]
Looking forward to PGConf India 2017
/0 Comments/in Pavan's PlanetPostgreSQL, PostgreSQL /by Pavan DeolaseeIt has taken a lot of planning and efforts, but I’m happy to see that PGConf India 2017 is coming along very well and promises to be a great event. This is our third year in a row in Bengaluru, but there are many distinguishing factors that make this year stand out: For the first […]
Schedule is live for pgDay Paris 2017 on March 23!
/0 Comments/in Vik's PlanetPostgreSQL /by Vik FearingpgDay Paris 2017 is the third annual one-day, one-track PostgreSQL conference, held in Paris, France. The schedule is live! This year, all presentations are in English in order to bring the very best of the international community to Paris and to show how PostgreSQL is used around the globe. Here is what you’ll see at pgDay […]