Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 39 Sekunden

Andrew Dunstan: When to deploy or upgrade to a new major PostgreSQL release

26. September 2020 - 0:08
With the release yesterday of PostgreSQL 13, now is perhaps a good time to talk about when and how it should be deployed. We often get questions at such times like "When should I upgrade?" and "Should I switch my new planned deployment to the new release?" The first thing to consider is this: you […]

Bruce Momjian: Cloud Vendors as a Barrier

25. September 2020 - 17:00

Cloud vendors are barriers like department stores and supermarkets are barriers. Huh? People associate these entities with providing a huge variety of goods and services, all in one place. How can that be a barrier?

Well, you are looking at it from the consumer perspective. For the producer, they are a mixed benefit. These "super sellers" allow access to much larger markets for most single-product producers, but they can have negatives for producers:

Liaqat Andrabi: New Features in PostgreSQL 13 [Full Webinar Video]

24. September 2020 - 15:49
The PostgreSQL Global Development Group today announced the release of PostgreSQL 13. The new release boasts improvements in performance and security as well as notable features such as the SQL-standard WITH TIES clause to use with LIMIT, B-tree deduplication, improvements for large databases, and more. The many features and enhancements in PostgreSQL 13 help improve […]

Egor Rogov: Indexes in PostgreSQL — 8 (RUM)

24. September 2020 - 2:00

We have already discussed PostgreSQL indexing engine, the interface of access methods, and main access methods, such as: hash indexes, B-trees, GiST, SP-GiST, and GIN.

John Porvaznik: Using Postgres and pgRouting To Explore The Smooth Waves of Yacht Rock

23. September 2020 - 21:07
pgRouting is a powerful routing tool, usually used for pathfinding/mapping/direction applications. (See Paul Ramsey's introduction to pgRouting here).

Bruce Momjian: Developers in Front

23. September 2020 - 15:30

Most companies have marketing and sales people as the visible part of their company. Technical people, even in technology companies, are often kept in the back, and only brought out for brief periods when needed. Open source is different — there are no marketing or sales teams, so software developers are the faces of projects. This gives technical people an opportunity to attain world-wide recognition for their efforts. There are not many places technical people can truly shine, but open source is one such opportunity.

Hans-Juergen Schoenig: Debugging PL/pgSQL: GET STACKED DIAGNOSTICS

23. September 2020 - 9:00

PL/pgSQL is the preferred way to write stored procedures in PostgreSQL. Of course there are more languages to write code available but most people still use PL/pgSQL to get the job done. However, debugging PL/pgSQL code can be a bit tricky. Tools are around but it is still not a fun experience.

One thing to make debugging easier is GET STACKED DIAGNOSTICS which us unfortunately not widely known. This post will show what it does and how you can make use of it.

Pavel Stehule: compiled dll of Orafce are available

23. September 2020 - 6:38

 Compiled dll of Orafce extension 3.13 can be downloaded from url

Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 13 – Support FETCH FIRST WITH TIES

22. September 2020 - 21:57
I have no idea how I missed that, but: if it wasn't for Alvaro's blog post I wouldn't know that: on 7th of April 2020, Alvaro Herrera committed patch: Support FETCH FIRST WITH TIES   WITH TIES is an option to the FETCH FIRST N ROWS clause (the SQL standard's spelling of LIMIT), where you … Continue reading "Waiting for PostgreSQL 13 – Support FETCH FIRST WITH TIES"

Kat Batuigas: Postgres Data Types in PL/Python

22. September 2020 - 19:04

I've been digging a little bit into PL/Python recently-inspired by our recent launch of Crunchy Bridge: a multi-cloud Postgres service with PL/Python and PL/R built right in.

Kat Batuigas: Postgres Data Types in PL/Python

22. September 2020 - 19:04

I've been digging a little bit into PL/Python recently-inspired by our recent launch of Crunchy Bridge: a multi-cloud Postgres service with PL/Python and PL/R built right in.

Avinash Kumar: Using Security Definer to Monitor PostgreSQL 9.6 or Earlier Using Percona Monitoring and Management

22. September 2020 - 15:45

I have previously written a blog post on the detailed steps involved in enabling PostgreSQL monitoring using PMM. In that post, you could see me talking about the role: pg_monitor that can be granted to monitoring users. The

Bruce Momjian: The Berkeley 39

21. September 2020 - 18:00

Postgres turns 34 this year. Michael Stonebraker, during his 2015 Turing Award speech (which I blogged about previously), included the names of the 39 Berkeley students (plus co-leader Larry Rowe) who helped write the original version of Postgres.

Andreas 'ads' Scherbaum: Dan Langille

21. September 2020 - 16:00
PostgreSQL Person of the Week Interview with Dan Langille: I am Canadian. Born in Nova Scotia and attended high school and university in Ottawa. I moved to New Zealand shortly after graduation. After 16 years in Wellington, NZ, where I got into Open Souce via FreeBSD, I moved back to Ottawa. I lived there for 6 years, then moved to USA. I now live in a small town outside Philadelphia.

Nils Dijk: Diary of an Engineer: Delivering 45x faster percentiles using Postgres, Citus, & t-digest

19. September 2020 - 10:00

When working on the internals of Citus, an open source extension to Postgres that transforms Postgres into a distributed database, we often get to talk with customers that have interesting challenges you won’t find everywhere. Just a few months back, I encountered an analytics workload that was a really good fit for Citus.

But we had one problem: the percentile calculations on their data (over 300 TB of data) could not meet their SLA of 30 seconds.

Kat Batuigas: Exploring PL/Python: Turn Postgres Table Data Into a NumPy Array

18. September 2020 - 18:30

PL/Python can be a convenient and powerful way to take advantage of your PostgreSQL database. In an earlier post, I talked a little bit about how you can use modules included in the Python standard library with PL/Python functions.

Bruce Momjian: Postgres and the Artificial Intelligence Landscape

18. September 2020 - 14:00

I recently wrote a presentation, Postgres and the Artificial Intelligence Landscape, which covers the basics of artificial intelligence and shows how Postgres can be used for this purpose. This week I presented it at the Chicago PostgreSQL Meetup Group so I am now publishing the slides.

Pavel Stehule: new release of pspg - pager for PostgreSQL, MySQL, MonetDB, PrestoSQL, ...

18. September 2020 - 7:15

I released new almost bug-fix release 3.1.4 of pspg. There is new light theme Flatwhite based on Dmitry Biletskyy flatwhite theme.

Marco Slot: Talking about Citus & Postgres at any scale

17. September 2020 - 10:20

I recently gave a talk about the Citus extension to Postgres at the Warsaw PostgreSQL Users Group. Unfortunately, I did not get to go in person to beautiful Warsaw, but it was still a nice way to interact with the global Postgres community and talk about what Citus is, how it works, and what it can do for you.

Egor Rogov: Indexes in PostgreSQL — 7 (GIN)

17. September 2020 - 2:00

We have already got acquainted with PostgreSQL indexing engine and the interface of access methods and discussed hash indexes, B-trees, as well as GiST and SP-GiST indexes. And this article will feature GIN index.