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.

Explore pgvector and its applications in Postgres databases. Learn more about vector similarity search and how to generate and store vector data.

Learn limitations of of Postgres; When and why companies should make the switch to a data lake from PostgreSQL

The complete tutorial of how to make use of popular technology to build a data engineering sandbox

The complete tutorial of how to make use of popular technology to build a data engineering sandbox

There is a web application which is running for a years and during its life time the application has gathered a lot of user data. Data is stored in relational DB (postgres). Not all of this data is

I was asked recently where PostgreSQL actually stores its data on disk. So I thought I’d share this.

Citus gives you all the greatness of Postgres plus the superpowers of distributed tables. By distributing your data and queries, your application gets high performance—at any scale. The Citus database is available as open source and as a managed service with…

dblink dblink — executes a query in a remote database Synopsis dblink(text connname, text sql [, bool fail_on_error]) returns setof …

F.11. dblink — connect to other PostgreSQL databases # dblink_connect — opens a persistent connection to a remote database dblink_connect_u — …

#knowledge360 #akramsohail #akramsohailproject
You Are Hearty Welcomed To My Channel Knowledge 360. Here I post technical videos, mainly related to computer science and programming. I am posting project videos with coding explanations. I make tutorial videos…

66.2. TOAST # 66.2.1. Out-of-Line, On-Disk TOAST Storage 66.2.2. Out-of-Line, In-Memory TOAST Storage This section provides an overview of TOAST (The …

Quiz link is here https://forms.gle/2mmS9VCJjFeZHbZh6

Topics -
* Toast internals
* Postgres toast strategies
* Postgres toast and performance
* Toast compression

How Postgres handles data storage of oversized attributes.

The Oversized-Attribure Storage Technique.

54.4. Streaming Replication Protocol # To initiate streaming replication, the frontend sends the replication parameter in the startup message. A Boolean …

Chirags Tutorial

Background:

I have a PostgreSQL (v8.3) database that is heavily optimized for OLTP.

I need to extract data from it on a semi real-time basis (some-one is bound to ask what semi real-time means a...