PostgreSQL Archives - 2ndQuadrant

PostgreSQL 12: Implementing K-Nearest Neighbor Space Partitioned Generalized Search Tree Indexes

November 5, 2019/3 Comments/in 2ndQuadrant, Kirk’s PlanetPostgreSQL, PostgreSQL /by Kirk Roybal

K-nearest neighbor answers the question of “What is the closest match?”. PostgreSQL 12 can answer this question, and use indexes while doing it.

Webinar: PostgreSQL Partitioning [Follow up]

October 28, 2019/1 Comment/in 2ndQuadrant, PostgreSQL, Webinars /by Bilal Ibrar

With the recent release of PostgreSQL 12, there’s been a lot of interest in the latest version and by popular demand, the team at 2ndQuadrant organized a live webinar on “PostgreSQL Partitioning”. The webinar was hosted by Simon Riggs, CTO 2ndQuadrant, who gave an overview of PostgreSQL partitioning features and how they play a key […]

Managing another PostgreSQL Commitfest

October 15, 2019/0 Comments/in 2ndQuadrant, Alvaro's PlanetPostgreSQL, PostgreSQL /by alvherre

I have written about managing a PostgreSQL commitfest before. During the PostgreSQL 13 development cycle, I did it again. This time I used a different strategy, mostly because I felt that there was excessive accumulation of very old patches that had received insufficient attention. So apart from bugfixes (which are always special cases), I focused […]

PostgreSQL 12: Foreign Keys and Partitioned Tables

October 14, 2019/4 Comments/in 2ndQuadrant, Alvaro's PlanetPostgreSQL, PostgreSQL /by alvherre

Now that PostgreSQL 12 is out, we consider foreign keys to be fully compatible with partitioned tables. You can have a partitioned table on either side of a foreign key constraint, and everything will work correctly. Why do I point this out? Two reasons: first, when partitioned tables were first introduced in PostgreSQL 10, they […]

Webinar: New Features in Postgres 12 [Follow up]

September 26, 2019/0 Comments/in 2ndQuadrant, PostgreSQL, Webinars /by Bilal Ibrar

The new PostgreSQL 12 release is just around the corner and by popular demand, the team at 2ndQuadrant hosted “New Features in Postgres 12″ webinar. The 1 hour + long session, conducted by Peter Eisentraut (Core Team Member of the PostgreSQL Project), gave an in-depth preview of everything new in PostgreSQL 12, improvements to partitioning, generated […]

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 […]