Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 2 Stunden 16 Minuten

Pavel Stehule: mandown - markdown terminal viewer

16. Juni 2020 - 7:11
My extensions and applications uses markdown format for documentation. There is new nice viewer - mandown - that allows viewing in terminal.

Bruce Momjian: Controlling Server Variables at Connection Time

15. Juni 2020 - 18:15

I have recently covered the importance of libpq environment variables and connection specification options. While most libpq options control how to connect to the Postgres server, there is one special option that can change variables on the server you connect to, e.g.:

Peter Eisentraut: Understanding user management in PgBouncer

15. Juni 2020 - 17:53
PgBouncer is a popular connection proxy and pooler for PostgreSQL. As PgBouncer presents a PostgreSQL protocol interface to client applications, it also handles client authentication. For that, it maintains its own directory of users and passwords. That is sometimes a source of confusion, so in this blog post I want to try to describe how […]

Andreas 'ads' Scherbaum: Tomas Vondra

15. Juni 2020 - 15:00
PostgreSQL Person of the Week Interview with Tomas Vondra: My name is Tomas Vondra, I live in Prague, and I’m a PostgreSQL user, developer, contributor and committer. I work for 2ndQuadrant, one of the companies contributing to PostgreSQL and providing services related to it, and I’m also involved in the local PostgreSQL community in various ways. Aside from that I do have various sports-related hobbies - cycling for example.

Peter Eisentraut: Understanding user management in PgBouncer

15. Juni 2020 - 11:01
PgBouncer is a popular connection proxy and pooler for PostgreSQL. As PgBouncer presents a PostgreSQL protocol interface to client applications, it also handles client authentication. For that, it maintains its own directory of users and passwords. That is sometimes a source of confusion, so in this blog post I want to try to describe how […]

Claire Giordano: Release notes for Citus 9.3, the extension that scales out Postgres horizontally

13. Juni 2020 - 19:20

Our latest release to the Citus open source extension to Postgres is Citus 9.3.

If you’re a regular reader of the Citus Blog, you already know Citus transforms Postgres into a distributed database, distributing your data and SQL queries across multiple servers. This post—heavily inspired by the internal release notes that lead engineer Marco Slot circulated internally—is all about what’s new & notable in Citus 9.3.

Shaun M. Thomas: PG Phriday: 10 Things Postgres Could Improve – Part 1

12. Juni 2020 - 20:00
Postgres is a database software engine with a lot to love, and certainly a non-zero amount to hate. Rather than approaching the topic from a glib and clickbaity angle, let’s see what’s really lurking in those dark recesses, and how we may potentially address them. Though the original blog post calling out Postgres’ faults gave […]

Bruce Momjian: Connect Parameter Specification Options

12. Juni 2020 - 19:00

I have previously covered the importance of libpq and environment variables. While you can specify discrete connection command-line parameters and environment variables, there is a catch-all setting that allows connection options to be specified in a single string, e.g.:

movead li: Transactions in PostgreSQL and their mechanism

12. Juni 2020 - 4:16

Transaction is the most basic concept of a database. Using begin and end command in PostgreSQL can start and commit a transaction. Of course, this is the most common PostgreSQL transaction. In addition, there are sub transaction, multi transaction, 2pc transaction concepts in PostgreSQL. In this blog, I will demonstrate the emergence scenario and kernel implementation of these PostgreSQL transactions.

Luca Ferrari: Running pgbackrest on FreeBSD

12. Juni 2020 - 2:00

pgbackrest is an amazing backup solution for PostgreSQL, quite frankly it is my favourite. And now fully supports FreeBSD too!

Semab Tariq: How to use AdaBoost Machine Learning model with 2UDA – PostgreSQL and Orange (Part 6)

11. Juni 2020 - 14:04
This article gives a step by step guide to utilizing Machine Learning capabilities with 2UDA. In this article, we will use examples of Animals to predict whether they are Mammals, Birds, Fish or Insects. Software versions We are going to use 2UDA version 11.6-1 to implement the Machine Learning model. This version 11.6-1 combines: PostgreSQL […]

Paul Ramsey: Developers Diary 2

11. Juni 2020 - 10:00

Have you ever watched a team of five-year-olds play soccer? The way the mass of children chases the ball around in a group? I think programmers do that too.

There’s something about working on a problem together that is so much more rewarding than working separately, we cannot help but get drawn into other peoples problems. There’s a lot of gratification to be had in finding a solution to a shared difficulty!

Even better, different people bring different perspectives to a problem, and illuminate different areas of improvement.

Magnus Hagander: Repartitioning with logical replication in PostgreSQL 13

10. Juni 2020 - 19:43

So, you have a partitioned table. And you want to change your mind. Re-partitioning is "easy" if you can take downtime -- just create a new table with a new name and copy all the data over. But what if we want to try to do it without downtime? Logical replication enhancements in PostgreSQL 13 brings us some new options for this!

But first a disclaimer -- this is definitely not pretty! And does not take into consideration things like foreign keys and similar. But sometimes a quick hack can be the best hack.

So let's go!

Craig Kerstiens: Control Runaway Postgres Queries With Statement Timeout

10. Juni 2020 - 18:08

Most queries against a database are short lived. Whether you're inserting a new record or querying for a list of upcoming tasks for a user, you're not typically aggregating millions of records or sending back thousands of rows to the end user. A typical short lived query in Postgres can easily be accomplished in a few milliseconds or less.

Bruce Momjian: Controlling Connection Parameters Using Environment Variables

10. Juni 2020 - 17:30

Libpq is the Postgres connection library used by almost every non-JDBC application. It allows many connection parameters, which can be specified on the command line or embedded in applications:

$ psql -h -d mydb

Continue Reading »

Hans-Juergen Schoenig: Composite type performance issues in PostgreSQL

10. Juni 2020 - 10:00

PostgreSQL is a really powerful database and offers many features to make SQL even more powerful. One of these impressive things is the concept of a composite data type. In PostgreSQL a column can be a fairly complex thing. This is especially important if you want to work with server side stored procedures or functions. However, there are some details people are usually not aware of when making use of stored procedures and composite types.

Ibrar Ahmed: Multi-Master Replication Solutions for PostgreSQL

9. Juni 2020 - 19:28

Due to the immense generation of data, scalability has become one of the hottest topics in the field of databases. Scalability can be achieved horizontally or vertically. Vertical scalability means adding more resources/hardware to existing nodes to enhance the capability of the database to store and process more data, for example, adding a new process, memory, or disk to an existing node. Every DBMS engine improves the capability of vertical scalability by improving the locking/mutex mechanisms and the concurrency by which it can use the newly added resources more effectively.

Steven Pousty: Using the Crunchy PostgreSQL Operator with PostGIS

9. Juni 2020 - 17:42

In today's blog post I am going to show you how to easily spin up PostGIS in your Kubernetes or OpenShift cluster using the PostgreSQL Operator.

Haroon .: RESTful CRUD API using PostgreSQL and Spring Boot – Part one

8. Juni 2020 - 16:58
Overview Spring Boot is a framework that is used to build stand-alone Java applications following the Spring framework but with less hassle and minimal configuration. Learning by practical examples is always great; therefore, this article will walk you through the creation of a RESTful CRUD (create-read-update-delete) application using Spring Boot and its connectivity with PostgreSQL. […]

Craig Ringer: Failover slots for PostgreSQL

8. Juni 2020 - 16:44
Logical decoding and logical replication is getting more attention in the PostgreSQL world. This means we need it working well alongside production HA systems – and it turns out there’s a problem there. Replication slots are not themselves synced to physical replicas so you can’t continue to use a slot after a master failure results […]