“It is paradoxical, yet true, to say, that the more we know, the more ignorant we become in the absolute sense, for it is only through enlightenment that we become conscious of our limitations. Precisely one of the most gratifying results of intellectual evolution is the continuous opening up of new and greater prospects.” Nikola Tesla […]
On the benefits of sorted paths
/17 Comments/in 2ndQuadrant, Featured, PostgreSQL, Tomas' PlanetPostgreSQL /by Tomas VondraI had the pleasure to attend PGDay UK last week – a very nice event, hopefully I’ll have the chance to come back next year. There was plenty of interesting talks, but the one that caught my attention in particular was Performace for queries with grouping by Alexey Bashtanov. I have given a fair number […]
PostgreSQL 9.6: Parallel Sequential Scan
/1 Comment/in Featured, Francesco's PlanetPostgreSQL, PostgreSQL /by Francesco CanovaiFor a long time, one of the most known shortcomings of PostgreSQL was the ability to parallelise queries. With the release of version 9.6, this will no longer be an issue. A great job has been done on this subject, starting from the commit 80558c1, the introduction of parallel sequential scan, which we will see […]
Evolution of Fault Tolerance in PostgreSQL: Replication Phase
/2 Comments/in 2ndQuadrant, Featured, Gulcin's PlanetPostgreSQL, PostgreSQL /by Gulcin YildirimPostgreSQL is an awesome project and it evolves at an amazing rate. We’ll focus on evolution of fault tolerance capabilities in PostgreSQL throughout its versions with a series of blog posts. This is the second post of the series and we’ll talk about replication and its importance on fault tolerance and dependability of PostgreSQL. If […]
Oracle’s rising open source problem
/0 Comments/in Simon's PlanetPostgreSQL /by Simon RiggsA salesman from Oracle recently spoke to my sales colleague at a conference, teasing him that he should “come make some money”. That was quite surprising, given Oracle’s well documented problems in gaining new sales, most especially what they say in their own public filings. The reply was unsurprisingly: “No, thanks – I’d like a […]
Evolution of Fault Tolerance in PostgreSQL
/0 Comments/in 2ndQuadrant, Featured, Gulcin's PlanetPostgreSQL, PostgreSQL /by Gulcin Yildirim“It is paradoxical, yet true, to say, that the more we know, the more ignorant we become in the absolute sense, for it is only through enlightenment that we become conscious of our limitations. Precisely one of the most gratifying results of intellectual evolution is the continuous opening up of new and greater prospects.” Nikola Tesla […]
Using Querydsl with PostgreSQL
/4 Comments/in Umair's PlanetPostgreSQL /by Umair ShahidQuerydsl is a domain model centric ORM that was created out of a need to add typesafety to HQL. As demonstrated in my blog on HQL, to write queries using HQL, at times long string concatenations need to be used. Such strings are not only hard to read, they are prone to runtime errors, avoiding […]
Letter from Japan
/0 Comments/in Ian's PlanetPostgreSQL /by Ian BarwickGreetings, honourable reader. My name is Barwick of the 2ndQuadrant Company. With the onset of the Plum Rain, in my humble estimation it has become hot and humid recently. I trust all is well in your exalted undertakings? No, I haven’t flipped a bit – the above is actually pretty much how a Japanese business […]
Concurrent backups with Barman and PostgreSQL 9.6
/1 Comment/in Featured, Gabriele's PlanetPostgreSQL /by Gabriele BartoliniPostgreSQL 9.6 has extended the traditional framework available for physical backups by allowing users to take backups concurrently. Barman will transparently support this new set of functions without requiring the pgespresso extension.
Conference isn’t enough?! Join us for post-conference training!
/0 Comments/in 2ndQuadrant, International News /by Britt ColeDid you know – 2ndQuadrant has the largest single, collection of PostgreSQL experts of any company globally?! With a team of some of the best known developers, they all still actively contribute to the progressive development of PostgreSQL. Would you like to have access to some of the most knowledgeable and experienced people available? The […]
Finding your PostgreSQL version
/0 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon RiggsQuestions How do you tell what version of PostgreSQL you are using? What is the version number of your PostgreSQL server? What’s the release of your Postgres server? What release is your Postgres database? How do I write a program that acts differently for different versions of the PostgreSQL server? Answer For a long time […]