Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 1 Stunde 38 Minuten

Peter Eisentraut: Running multiple PgBouncer instances with systemd

13. August 2020 - 20:13
Since PgBouncer runs as a single process, it is not straightforward to make use of multiple CPUs on a host. When you are running on real hardware, this is wasteful, since single-CPU server machines don’t exist anymore, as far as I can tell. When using virtualization, you could just provision a single CPU per virtual […]

Bruce Momjian: Keyset Pagination

12. August 2020 - 13:45

Having covered pagination in a previous blog post, I want to explore method #5, LIMIT/OFFSET and WHERE, also called keyset or seek pagination. This method avoids many of the performance pitfalls and inconsistent results of the other methods, but it comes with its own complexities.

Laurenz Albe: Understanding recursive queries in PostgreSQL

12. August 2020 - 10:00


© Laurenz Albe 2020

Many people consider recursive queries a difficult topic. Still, they enable you to do things that would otherwise be impossible in SQL.

This articles gives a simple introduction with examples and shows the differences to Oracle’s implementation of recursive queries.

Common table expressions (WITH clauses)

A common table expression (CTE) can be seen as a view that is only valid for a single query:

Dan Langille: ignore case when browsing to a cat/port – the details of how to do that

12. August 2020 - 1:24
This idea came to me today from swills: stupid question, would it be possible to make the urls on freshports case insensitive? so that like https://www.freshports.org/x11/libx11 would go to https://www.freshports.org/x11/libX11 After confirming this was for manually typed URLs (as opposed to generated links), I started looking into it. This is what I found. In this [...]

Steven Pousty: Iterators in PostgreSQL with Lateral Joins

11. August 2020 - 16:48

There you are writing some SQL, having a great time. Uh oh, you need to iterate over each item in a result set and apply a function. You think, "Now I am going to have to write a stored procedure." Well today's post will give you an alternative by using lateral joins in Postgres

 Lateral pass.... See what I did there?

Pavel Stehule: Gnome-terminal with sixel support

11. August 2020 - 13:47

I like terminal applications - usually TUI applications are fast and clean, and well readable.  This interface is too simply, and then developers has to much more think about UI, and has not too much possibilities. On second hand sometimes the output of terminal applications are too limited. We run our terminal from GUI (usually), and then some graphic possibilities can be practical - graphs are better in pixel graphics than ascii art.

Muhammad Usama: Consensus based failover with Pgpool-II

11. August 2020 - 10:45

Pgpool-II probably is the most comprehensive clustering solution existing today for PostgreSQL. It provides a wide range of features like connection pooling, load balancing, automatic failover and high availability while using the Pgpool-II for load balancing and building a highly available PostgreSQL cluster is one of its most common use case.

Hamid Akhtar: PostgreSQL High Availability: The Considerations and Candidates

10. August 2020 - 22:48

Almost every organisation that I interact with wants a high availability system for PostgreSQL. This clearly depicts an active trend toward an increase in utilising PostgreSQL for critical business applications. In some cases it is a move away from other major database systems like Oracle or even Teradata.

Bruce Momjian: Pagination Tips

10. August 2020 - 16:00

We have all used applications that allow searches which return results in sections or "pages", like for products or flights. For example, you might search for a product, and there might be 1,500 matches, but you don't see 1,500 results — you only see ten results (1-10), and you have the option of seeing the next ten (11-20), and the next ten (21-30), etc. Pagination is done for several reasons:

Andreas 'ads' Scherbaum: Michael Brewer

10. August 2020 - 16:00
PostgreSQL Person of the Week Interview with Michael Brewer: I live in Athens, Georgia (USA), the city where I was born (and have lived in or near most of my life). I’m a Web Developer Principal for the Franklin College of Arts and Sciences at The University of Georgia, my alma mater. I also play bass trombone in the Athens Symphony, am principal conductor of the Classic City Band (Georgia’s oldest continuously-operating community band), Director of Music at Emmanuel Episcopal Church, music director of the Athens Brass Choir, and also conduct a new local opera company, RespirOpera.

Seiten