PostgreSQL DBA – Telegram

PostgreSQL DBA

2.15K subscribers

91 photos

1 video

20 files

216 links

Sharing knowledge about postgresql database

Download Telegram

About

Blog

Apps

Platform

2.15K subscribers

https://medium.com/@razi_chaudhry/developing-a-big-data-strategy-637c0fa120b0

Developing a Big Data Strategy

Developing big data strategy and modern data visualization, building data sciences like simulation, regression & correlation, trending &…

👍1

1.17K views02:20

https://youtu.be/nGAG5kqlM5E

Introduction to Big Data Techniques

Introduction to Big Data Techniques (2025 CFA® Level I Exam – Quantitative Methods – LM 11)

Prep Packages for the CFA® Program offered by AnalystPrep (study notes, video lessons, question bank, mock exams, and much more):
Levels I, II & III (Lifetime access): https://analystprep.com/shop/cfa-unlimited-package-for-level-1-2-3/

Level I: https://…

🙏1

1.26K views02:46

https://www.youtube.com/watch?v=KCEPoPJ8sWw

Big Data Full Course 2022 | Big Data Tutorial For Beginners

Big Data Full Course 2022 | Big Data Tutorial For Beginners | Big Data Step By Step | Simplilearn

🔥 Cloud Architect Masters Program - https://www.simplilearn.com/cloud-solutions-architect-masters-program-training?utm_campaign=KCEPoPJ8sWw&utm_medium=DescriptionFFF&utm_source=Youtube
️‍🔥Purdue - Cloud Computing and DevOps Certification Program - https:…

1.02K views06:38

https://www.youtube.com/watch?v=3v7NhwhXIyE

Data Preparation | Data Journey | 7 Challenges of Big Data Analytics

Episode 2 | Data Preparation | Data Journey | 7 Challenges of Big Data Analytics

Data preparation issues, particularly at scale, can be solved. How? Thomas Hazel explains in episode 2 of our binge-worthy #datajourney series.

#reInvent #KnowBetter #RoadtoreInvent #DataJourney #DevOps #SRE #DataEngineers #DataScientists #datapipelines…

1.12K views06:39

https://www.youtube.com/watch?v=TAtfkrjtAYM

Journey to data insight | Four principles to guide you

Journey to data insight | Four principles to guide you

Do you question if your visualizations lead to actionable decisions? Do you struggle with helping users who are tantalized by pretty visuals but missing inspiring insights? Do your users change what they want on a regular basis?
Hear a Tableau Zen Master…

🤝1

1.43K views06:55

https://www.netsuite.com/portal/resource/articles/data-warehouse/data-lake.shtml

Oracle NetSuite

Data Lake Defined

A look at how data lakes let businesses store and analyze all unstructured and structured big data.

1.11K views03:20

https://wiki.postgresql.org/wiki/PostgreSQL_derived_databases

A list of PostgreSQL derived forks and rebranded distributions in alphabetical order.

👍1

938 viewsedited 02:32

To Understand The Fork process will run different ID with the same Postmaster ID

👍1

1.06K views02:52

👍1

1.03K views02:52

The postmaster ID will be assigned once the cluster is started based on this ID other background processes will starts and running on different ID with the same parent ID. This postmaster ID will changes when the cluster is stop and starts.

👍2

1.22K viewsedited 02:53

https://www.youtube.com/watch?v=sP5nbdNxaQc

A PostgreSQL fork for horizontal scalability

PGConf India 2024 - A PostgreSQL fork for horizontal scalability: by Franck Pachot (Yugabyte)

PGConf India 2024 - A PostgreSQL fork for horizontal scalability: YugabyteDB by Franck Pachot (Yugabyte)

👍2

1.46K views02:55

https://akashcsharma.medium.com/demystifying-database-internals-part-2-deep-dive-into-storage-engine-of-dbms-episode-i-paging-2f748a078d22

Deep dive into Storage Engine of DBMS Episode I(Paging, Buffer Pool Manager, Write Ahead Log)

Deep dive into Storage Engine of DBMS Episode I(Paging, Buffer Pool Manager, Write Ahead Log)

👍1

1.03K views06:51

https://akashcsharma.medium.com/demystifying-database-internals-part-2-deep-dive-into-storage-engine-of-dbms-episode-ii-query-4f9d6ba35670

Deep dive into Storage Engine of DBMS Episode II(Query Planning/ Optimization, Execution, Transaction Manager, Lock Manager, Concurrency…

❤1

1.03K views07:09

https://www.linkedin.com/pulse/understanding-data-corruption-postgresql-shyam-kumar-9kvwc

Understanding Data Corruption in PostgreSQL

Understanding Data Corruption in PostgreSQL

Data corruption is a real challenge in any technical environment. Imperfections in technical equipment can lead to data damage, whether in memory, on disk, or during transfer via interface cables.

909 views06:54

https://www.highgo.ca/2021/01/27/avoiding-identifying-and-dealing-with-postgresql-database-corruption-part-1/
Avoiding, Identifying, and dealing with PostgreSQL database corruption

Highgo Software Inc. - Enterprise PostgreSQL Solutions

Avoiding, Identifying, and dealing with PostgreSQL database corruption - Part 1 - Highgo Software Inc.

All the things that can happen to databases, corruption is not the one that happens frequently, but when it does it can result in major downtime and data loss. Probably it is one of the most terrifying things for a DBA to come across and the best way to deal…

879 views06:56

https://www.cybertec-postgresql.com/en/how-to-corrupt-your-postgresql-database/

How to corrupt your PostgreSQL database

CYBERTEC PostgreSQL | Services & Support

How to corrupt your PostgreSQL database

This article shows how to corrupt a PostgreSQL database - or what you should avoid if you don't want a corrupted database.

❤1👍1

971 views06:56

https://rasiksuhail.medium.com/guide-to-postgresql-table-partitioning-c0814b0fbd9b#:~:text=Hash%20partitioning%20in%20PostgreSQL%20is,Partition%20makes%20querying%20faster.

Guide to PostgreSQL Table Partitioning

Guide to PostgreSQL Table Partitioning

PostgreSQL is a powerful open-source relational database management system that offers various advanced features for managing large and…

782 views10:42

https://www.timescale.com/learn/when-to-consider-postgres-partitioning

When to Consider Postgres Partitioning

When to Consider Postgres Partitioning | Timescale

Postgres partitioning is a powerful tool for scaling your database. This guide explains how partitioning works and when to use it.

844 views10:43

https://www.postgresql.fastware.com/postgresql-insider-prt-ove

Partitioning

PostgreSQL Insider - What are the partitioning types available in PostgreSQL, and how should I choose one?

This article explains partitioning, the method for storing data in divided tables, based on declarative partitioning.

802 views10:44

https://sparktpoint.com/postgresql-partition-by/
PARTITION BY in PostgreSQL

Spark Tutorial Point

Using PARTITION BY in PostgreSQL - Apache Spark Tutorial

In PostgreSQL, an advanced SQL feature that helps in managing large tables efficiently is table partitioning, which can be crafted using the 'PARTITION BY'

989 views10:45