Sammlung von Newsfeeds
© Laurenz Albe 2020
In my daily work, I see many databases with a bad setting for max_connections. There is little advice out there for setting this parameter correctly, even though it is vital for the health of a database. So I decided to write up something.
CREATE TABLE user_pool_clean (
fk_user_pool_pk bytea NOT NULL,
user_id character varying(255) NOT NULL,
email_address character varying(250),
role_id character varying(50),
user_profile_id character varying(50),
This is one of the most common questions asked by developers who write SQL queries against the PostgreSQL database. There are multiple ways in which a sub select or lookup can be framed in a SQL statement. PostgreSQL optimizer is very smart at optimizing queries, and many of the queries can be rewritten/transformed for better performance.
Let’s discuss the topic with an example, for which I am using schema created by pgbench.
2020 April 23 Meeting 6:30pm-8:30pm
Note: This will be an online event. You must RSVP to get the link to the meeting, which will be set shortly before the meeting as we will be using Jitsi. Jitsi can be used directly with Firefox and Chrome (with extension), or phones/tablets with the Jitsi Meet app.
Speaker: Paul Jungwirth
In the context of transaction processing, Isolation plays a significant role.
Isolation is the property that controls how and when changes are made and when they must be visible to each other, users, and systems.
PostgreSQL achieves Isolation by multi-version concurrency control architecture.
Multi-version concurrency control is a technique to allow multiple sessions to access the same record concurrently, i.e., while session A is updating a record, session B can still access the record.
In times of COVID-19, governments contemplate tough measures to identify and trace infected people. These measures include the utilization of mobile phone data to trace down infected individuals and subsequently contacts to curb the epidemic. This article shows how PostGIS’ functions can be used to identify “overlapping” sections of infected and healthy individuals by analysing tracks spatio-temporally.
This time we don’t focus on performance and tuning, rather strive boosting your creativity on PostgreSQL’s spatial extension and its functionalities.
Command Prompt is one of the oldest Postgres support companies in the world and we have been blessed to be extremely busy with Professional community development including meetups and conferences. With the current climate we thought it would also be useful to remind people of “Simple Tips”. Simple tips will help new users of Postgres and related technologies to answer those pesky little questions that are in the back of their heads about how to do “insert idea here”.How to add seconds to a timestamp to get an ending timestamp?
Assume you have have 2 values:
I was going a give a short talk on this subject in pgconf New York 2020, however the conference like many other conference this year unfortunately got cancelled due to COVID-19. So I have decide to write a short about this schema object introduced in PG 11. As a Oracle database developer / DBA I had made extensive use of stored procedure so finally it landed in PostgreSQL in PG 11.
Andreas 'ads' Scherbaum
The PostgreSQL main website has a new page: "Related Projects".
This page lists the projects which help running and maintaining the PostgreSQL project, the infrastructure, and other things like the translations for press releases. For each project it lists links to the source, as well as information where to send updates, patches, or input.
Semab Tariq: How to use the Random Forest Machine Learning Model with 2UDA – PostgreSQL and Orange (Part 3)
The last two months, I managed the agenda for our weekly Citus team meeting, the one time each week where our entire distributed team—with people spread across 6 different countries—gets together to talk about Citus things. As I chatted with our PostgreSQL folks to find speakers to give 10-minute “lightning talks”, I heard a chorus from several of the engineers: “see if you can get Joe to give a talk. His talks are always super interesting.”
I’m seeing that around all the world the conferences are being cancelled. This is also true for PostgreSQL related conferences.
In this article, we describe a recent enhancement to pg_dump that Swarm64 contributed that more fully supports the backup and restoration of foreign tables. The contribution has been committed to PostgreSQL 13.