Many years ago, Michelle Caise submitted a patch to generate code coverage reports for the PostgreSQL code base, based on the lcov utility. Although I cannot find any record of an actual patch in the mailing list archives, Peter Eisentraut committed it some time later, and applied further refinements later. Today I’m announcing a new […]
On the usefulness of expression indexes
/0 Comments/in 2ndQuadrant, PostgreSQL, Tomas' PlanetPostgreSQL /by Tomas VondraWhen teaching PostgreSQL trainings, both on basics and advanced topics, I often find out the attendees have very little idea how powerful the expression indexes may be (if they are aware of them at all). So let me give you a brief overview. So, let’s say we have a table, with a range of timestamps […]
9.6 Scariest Patch Tournament
/0 Comments/in Alvaro's PlanetPostgreSQL, PostgreSQL /by Álvaro HerreraPostgreSQL’s Release Management Team is requesting your input on patches that are most likely to cause bugs or instability. I’m sure you have an opinion on that! Please cast your votes by filling this form.
Postgres-XL 9.5r1 has finally arrived!
/2 Comments/in 2ndQuadrant, Pavan's PlanetPostgreSQL /by Pavan DeolaseeAfter months of efforts, I’m pleased that Postgres-XL 9.5r1 is seeing the daylight. It has been tremendous collective efforts by many, both inside and outside 2ndQuadrant. Often it’s not visible via commit history or mailing list communications, but I must admit that many folks have contributed in making this grand release. Contributors who wrote code […]
Code coverage stats
/0 Comments/in Alvaro's PlanetPostgreSQL, PostgreSQL /by Álvaro HerreraMany years ago, Michelle Caise submitted a patch to generate code coverage reports for the PostgreSQL code base, based on the lcov utility. Although I cannot find any record of an actual patch in the mailing list archives, Peter Eisentraut committed it some time later, and applied further refinements later. Today I’m announcing a new […]
pgpredict – Predictive analytics in PostgreSQL
/0 Comments/in 2ndQuadrant, Data Mining, Lan's PlanetPostgreSQL, PostgreSQL /by Lan ZagarWe all realize how important it is to be able to analyze the data we gather and extract useful information from it. 2UDA is a step in that direction and aims to bring together data storage and management (PostgreSQL) with data mining and analysis (Orange). pgpredict is a project in development and aims to be […]
What is SKIP LOCKED for in PostgreSQL 9.5?
/27 Comments/in Craig's PlanetPostgreSQL /by craig.ringerPostgreSQL 9.5 introduces a new SKIP LOCKED option to SELECT … FOR [KEY] UPDATE|SHARE. It’s used in the same place as NOWAIT and, like NOWAIT, affects behaviour when the tuple is locked by another transaction. The main utility of SKIP LOCKED is for building simple, reliable and efficient concurrent work queues.
Planning to succeed
/5 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon RiggsPostgreSQL 9.6 has a lot of good features; many of the changes are in the SQL planner, aiming to improve performance by carefully selecting the right execution plan. The great thing here is that doing less work makes many queries much, much faster than they were before. First, we are now using Foreign Key data […]
Postgres-XL 9.5R1Beta2 Released!
/0 Comments/in Pavan's PlanetPostgreSQL /by Pavan DeolaseeThe Postgres-XL 9.5R1Beta2 release went out yesterday. It’s another step forward to have a stable 9.5 release sometime very soon. A few key enhancements from the last beta release are captured in this blog. For the full list, I would recommend to read the release notes. Support for binary data transfer for JDBC and libpq If […]
PostgreSQL User Group NL
/0 Comments/in Gianni's PlanetPostgreSQL, International News, PostgreSQL, User Group /by Gianni CiolliLast week I was invited by the Dutch PostgreSQL User Group in Amsterdam to speak on PostgreSQL Administration Recipes. It was the first session of 2016, and the third since they started meeting last year. Using the simple format of a cooking recipe, I presented some techniques that a PostgreSQL DBA can use to solve […]