PostgreSQL Archives - 2ndQuadrant

Webinar: Business Intelligence with Window Functions in PostgreSQL [Follow up]

August 29, 2019/0 Comments/in PostgreSQL, Webinars /by Bilal Ibrar

Window functions are a very useful tool; and since their introduction 10 years ago, they have been gradually adopted for various use cases where a simple aggregation is not flexible enough: for example incremental totals, moving averages, etc. The latest features introduced in PostgreSQL complete the implementation according to the SQL:2011 standard, adding capabilities such […]

Webinar: Security and Compliance with PostgreSQL [Follow Up]

April 25, 2019/0 Comments/in PostgreSQL, Webinars /by Bilal Ibrar

For businesses handling personal data, security of their database is a serious matter. Faced with an increasing number of attacks, an organization must improve their security and compliance policies, improve their database infrastructure and ensure all proper security protocols are in place.

Postgres is the coolest database – Reason #2: The License

April 24, 2019/0 Comments/in PostgreSQL, Umair's PlanetPostgreSQL /by Umair Shahid

Legal documents = SCARY!! That’s the typical equation, and it’s true – except when it comes to PostgreSQL. Let me explain… I have been told by both prospects and clients, that when they sit down to negotiate terms with Oracle, they are faced with more lawyers than they have engineers. No wonder one shudders at […]

Postgres is the coolest database – Reason #1: Developers love it!

April 8, 2019/3 Comments/in PostgreSQL, Umair's PlanetPostgreSQL /by Umair Shahid

PostgreSQL has been my livelihood since 2004 – so I am naturally biased in its favor. I think it is the coolest piece of software on the planet, and I am not alone. DB-Engines See those 2 badges up there? That’s 2 years in a row. DB-Engines monitors a total of 343 databases and their […]

Having Group By Clauses — elein’s GeneralBits

March 18, 2019/0 Comments/in Elein’s PlanetPostgreSQL, PostgreSQL /by Elein

Some people go to great lengths to avoid GROUP BY and HAVING clauses in their queries. The error messages are fussy but they are usually right. GROUP BY and HAVING key words are essential for good SQL reporting. The primary reason for GROUP BY is to reduce the number of rows, usually by aggregation. It […]

JOIN LATERAL

March 1, 2019/2 Comments/in Elein’s PlanetPostgreSQL, PostgreSQL /by Elein

LATERAL The primary feature of LATERAL JOIN is to enable access elements of a main query in a subquery which can be very powerful. Several common uses of LATERAL are to: denormalize arrays into parent child tables aggregation across several tables row or action generation. Note, however, that the subquery will execute for each main […]

Webinar: Banking on Postgres – Financial Application Considerations [Follow up]

January 30, 2019/0 Comments/in Liaqat's PlanetPostgreSQL, PostgreSQL, Webinars /by Liaqat Andrabi

The demand for PostgreSQL within the financial industry has been rapidly increasing in the recent years; mainly due to reduction in licensing costs, better choice of open source tools, and the robust enterprise features that PostgreSQL provides. 2ndQuadrant hosted the “Banking on Postgres” webinar to discuss attributes of financial databases based on Postgres, configuration processes, […]

PostgreSQL 9.3 EOL – Why is it Important to Upgrade?

January 3, 2019/0 Comments/in 2ndQuadrant, Liaqat's PlanetPostgreSQL, PostgreSQL /by Liaqat Andrabi

After the final release of patch 9.3.25 on November 8th 2018, PostgreSQL 9.3 is no longer supported. Therefore it’s time for all users of PG 9.3 to upgrade their databases to a newer supported version. The benefits of having a supported version are many and that’s what Craig Ringer talks about in the Q&A session […]

[Video] Ansible and PostgreSQL

December 12, 2018/0 Comments/in PostgreSQL, Tom's PlanetPostgreSQL /by Tom Kincaid

I don’t often get to speak on technical topics, but the video of my presentation below covers various concepts around “Ansible and PostgreSQL” – something I am very enthusiastic about. This presentation covers the following topics: Overview of Ansible and PostgreSQL Best strategies for mixed cloud and on-premises deployments How to deploy AlwaysOn PostgreSQL clusters […]

Managing Freezing in PostgreSQL

October 10, 2018/2 Comments/in Andrew's PlanetPostgreSQL, PostgreSQL /by Andrew Dunstan

Postgres contains a moving event horizon, which is in effect about 2 billion transactions ahead of or behind the current transaction id. Transactions more than 2 billion ahead of or more than 2 billion behind the current transaction id are considered to be in the future, and will thus be invisible to current transactions. Postgres […]