Posts
“Now is Better Than Never” – Why I decided to attend PyCon8…
/0 Comments/in 2ndQuadrant, Britt's PlanetPostgreSQL /by Britt Cole…and why I’m glad I did. It’s not all technical… Who knew?! Last year, Pycon7 was held right about the time I joined 2ndQuadrant. Seeing as I was new to the technology AND the Italian language (note: there was an English track), I opted out of attending. Well, after attending Pycon8, I can say that […]
Using the PostgreSQL TAP framework in extensions
/3 Comments/in Craig's PlanetPostgreSQL /by craig.ringerSupport for using the TAP protocol to run extended regression tests was added to PostgreSQL back in 9.4 with the adoption of Perl’s prove tool and Test::More to test initdb, pg_basebackup, etc. Since then the TAP-based tests have been greatly expanded, particularly with the advent of the src/test/recovery tests and the PostgresNode module in PostgreSQL […]
Traceable commit for PostgreSQL 10
/0 Comments/in Craig's PlanetPostgreSQL /by craig.ringerPostgreSQL 10 now supports finding out the status of a recent transaction for recovery after network connection loss or crash.
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 […]
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 […]
Corruption in CREATE INDEX CONCURRENTLY
/1 Comment/in Pavan's PlanetPostgreSQL /by Pavan DeolaseeTwo weeks back we discovered an ancient bug in PostgreSQL which may cause index corruption when index is built via CREATE INDEX CONCURRENTLY (aka CIC). All supported releases of PostgreSQL are affected by this bug. The bug could be a source of index corruption reports that we receive from the field once in awhile. Now […]