Neues vom PostgreSQL Planet

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

Dave Page: Regression Analysis in PostgreSQL with Tensorflow: Part 2 - Data Pre-processing

vor 7 Stunden 30 Minuten
In part 1 of this blog mini-series on machine learning, we looked at how to setup PostgreSQL so that we can perform regression analysis on our data using TensorFlow from within the database server using the pl/python3 procedural language. We also looked at some of the basics of pl/python3 as a primer for what is to come in this and part 3 of the series.

Amit Khandekar: A quick sanity testing of PostgreSQL parallel query on Arm64

vor 7 Stunden 36 Minuten
Query parallelism is supported in PostgreSQL since quite a while now. People in the PG community call it "Parallel query", but by now it is not limited to just SELECT queries. Index build leverages multiple cores; and even utilities like VACUUM now make use of parallelism. Furthermore, community is working on parallelizing COPY and INSERTs.                                                                                  I was interested to do kind-of "sanity" check of this capability specifically on ARM64 platform. Let's see how it goes.

Hans-Juergen Schoenig: Cleaning up a large number of BLOBs in PostgreSQL

vor 12 Stunden 3 Minuten

PostgreSQL allows end users to store BLOBs (binary large objects) in the database. Many people use these functions to handle data directly in SQL. There has long been a discussion about whether this is a good thing or not. We expect that particular discussion to go on indefinitely. However, if you are in the “pro BLOB” camp, we want to share some insights into how binary data can be handled in PostgreSQL with maximum efficiency.

Bruce Momjian: Shared Memory Sizing

12. April 2021 - 18:00

Postgres makes extensive use of operating system shared memory, and I have already written a presentation about it. The Postgres documentation gives specific instructions on how to determine the amount of shared memory allocated, specifically for sizing huge pages.

Andreas 'ads' Scherbaum: Devrim Gündüz

12. April 2021 - 16:00
PostgreSQL Person of the Week Interview with Devrim Gündüz: I’m a community person. Ex-Turkey, now Londoner. Started using Linux in 1996, and PostgreSQL in 1998. Love to travel, listen to music, and enjoy life with friends. Started working around 2000. Joined PostgreSQL community around 1999. Working for EnterpriseDB since 2010, and also running two PostgreSQL companies in Turkey and in the UK.

Keith Fiske: Managing Transaction ID Exhaustion (Wraparound) in PostgreSQL

12. April 2021 - 8:56

One of the most critical topics to understand when administering a PostgresSQL database is the concept of transaction IDs (TXID) and that they can be exhausted if not monitored properly. However, this blog post isn’t going to go into the details of what it TXID exhaustion actually is. The Routine Vacuuming section of the documentation is probably one of the most important to read and understand so I will refer you there.

Keith Fiske: Managing Transaction ID Exhaustion (Wraparound) in PostgreSQL

12. April 2021 - 8:56

One of the most critical topics to understand when administering a PostgresSQL database is the concept of transaction IDs (TXID) and that they can be exhausted if not monitored properly. However, this blog post isn’t going to go into the details of what it TXID exhaustion actually is. The Routine Vacuuming section of the documentation is probably one of the most important to read and understand so I will refer you there.

Marco Slot: Citus Talk at CMU: Distributed PostgreSQL as an Extension

10. April 2021 - 18:28

Last month we released Citus 10 and we’ve received an overwhelming amount of positive feedback on the new columnar compression and single node Citus features, as well as the news that we’ve

Avinash Vallarapu: pgBackRest – The Best Postgres Backup Tool with a very active community

10. April 2021 - 1:52

A reliable backup tool with an ability to perform a point in time recovery (PITR) is a usual enterprise need. Postgres includes a backup tool called pg_basebackup for full backups. It is great for a database of a few hundreds of GBs in size but currently lacks the support for parallel, incremental and differential backups. This makes it slightly challenging for bigger postgres databases that are Terrabytes in size. pgBackRest is our savior in such a case.

David Steele: Introducing pgBackRest Multiple Repository Support

9. April 2021 - 20:42

The pgBackRest team is pleased to announce the introduction of multiple repository support in v2.33. Backups already provide redundancy by creating an offline copy of your PostgreSQL cluster that can be used in disaster recovery. Multiple repositories allow you to have copies of your backups and WAL archives in separate locations to increase your redundancy and provide even more protection for your data.

Bruce Momjian: Replica Scaling by the Numbers

9. April 2021 - 15:30

I have previously blogged about scaling of read-only and read/write workloads. Inspired by this email thread, I want to be more specific about exactly what scaling you can expect by using read-only replicas. First, as the email poster pointed out, read replicas still have to replay write transactions from the primary server.

ahsan hadi: How to run Hierarchical Queries with PostgreSQL

9. April 2021 - 13:24

A hierarchical query is built upon parent-child relationship, the relationship exist in the same table or view. The relationship dictates that each child can have one parent while a parent can have many children. Hierarchical query is a SQL query that handles data of hierarchical model i.e. an organisation structure where every employee has one manager and one manager who is also an employee can have many employees in his reporting, another example is a family tree where one person can only have one parent while a person can have many children.

Hans-Juergen Schoenig: Getting started with QGIS, PostgreSQL and PostGIS

8. April 2021 - 9:30

Visualizing spatial data is an important task. In this mini-tutorial, you will learn how to quickly visualize OpenStreetMap (OSM) data with PostGIS and QGIS. The idea is to get you started as fast as possible, and to make the most out of your data.

Installing QGIS

QGIS is freely available as Open Source software and can be used free of charge. It is a powerful tool to edit and visualize spatial data which is ideally stored in a PostGIS-enabled PostgreSQL database.

Bruce Momjian: Operating System Choice

7. April 2021 - 16:45

In the 1990's, most server operating systems were closed-source and produced by a few billion-dollar companies. In recent years, Red Hat Enterprise Linux (RHEL) became the default enterprise server operating system, with CENTOS filling the need for installations on smaller platforms and in the cloud.

Mark Wong: PDXPUG April 2021: Tidying Up Your Data with The San Francisco Bay Area PostgreSQL Meetup Group

7. April 2021 - 1:57

Join us virtually on April 13, 2021 at 12:00PM,

Muffy Barkocy presents, “Tidying Up Your Data”.

Craig Kerstiens: Announcing Google Cloud Storage (GCS) Support for pgBackRest

6. April 2021 - 20:49

Crunchy Data is pleased to announce its most recent release of pgBackRest: 2.33 with a number of new features including multiple repository support and GCS support.

Federico Campoli: Deploying PostgreSQL for High Availability with Patroni, etcd and HAProxy – Part 2

6. April 2021 - 14:36
Deploying PostgreSQL for High Availability with Patroni, etcd and HAProxy – Part 2 l by Federico Campoli  6 Apr, 2021 

Hans-Juergen Schoenig: PostgreSQL: Get member roles and permissions

6. April 2021 - 10:00

PostgreSQL provides a highly sophisticated and powerful security and permission system. It allows you to define users (= roles), groups and so on. However, without a graphical user interface, it is usually a bit tricky to figure out which role is assigned to whom. The following blogpost explains how this can be done. Learn how to retrieve information on roles and role membership in PostgreSQL.

Preparing users and roles

To show how users can be analyzed, we first create a couple of users and roles:

Bruce Momjian: Many Upgrade Methods

5. April 2021 - 16:00

Databases are often a critical part of enterprise infrastructure, so when and how to upgrade them is a common discussion topic among database administrators, and Postgres is no exception. The Postgres community has a web page about when to upgrade, and the Postgres documentation has a section about upgrading.

Lætitia AVROT: A Tip a day takes the GUI away!

4. April 2021 - 21:21
Hello everyone! This is the first (and maybe last) time I won’t have anything technical to publish on this blog. I worked hard on a project lately and I’m proud and excited to announce that Psql Tips is now published! This URL is great if you’d like to get a random tip, but you can look here at all of them on a single page! For now, there are only 100 tips but stay tuned, I plan to add more in the following weeks!

Seiten