PostgreSQL DBA – Telegram

PostgreSQL DBA

2.08K subscribers

37 photos

20 files

189 links

Sharing knowledge about postgresql database

Download Telegram

About

Blog

Apps

Platform

2.08K subscribers

https://www.pgedge.com/blog/achieving-high-availability-ha-in-postgresql-strategies-tools-and-best-practices

Achieving PostgreSQL High Availability: Strategies, Tools, and Best Practices

PostgreSQL High Availability: Strategies, Tools, and Best Practices

This blog offers a deep dive into the topic of Postgres high availability and various approaches for achieving HA Postgres. Learn about various options and pros and cons of each.

847 views08:06

https://www.cybertec-postgresql.com/en/postgresql-security-things-to-avoid-in-real-life/

PostgreSQL Security: 12 rules for database hardening

CYBERTEC PostgreSQL | Services & Support

PostgreSQL Security: 12 rules for database hardening

UPDATED August 2023: PostgreSQL security - make your database safe. Follow these 12 recommendations for proactive database hardening.

706 views06:28

https://cheatsheetseries.owasp.org/cheatsheets/Database_Security_Cheat_Sheet.html

Database Security Cheat Sheet

cheatsheetseries.owasp.org

Database Security - OWASP Cheat Sheet Series

Website with the collection of all the cheat sheets of the project.

692 views06:29

https://github.com/HexaCluster/pgdsat

PGDSAT is a security assessment tool

GitHub - HexaCluster/pgdsat: PostgreSQL Database Security Assessment Tool

PostgreSQL Database Security Assessment Tool. Contribute to HexaCluster/pgdsat development by creating an account on GitHub.

833 views06:29

https://support.huawei.com/enterprise/br/doc/EDOC1100293173/7512640c/postgresql-database-hardening

PostgreSQL Database Hardening

704 views06:30

https://www.timescale.com/learn/postgres-security-best-practices

Best Practices for Postgres Security

Best Practices for Postgres Security | Timescale

How do you keep your PostgreSQL data secure? Here are the top best practices for PostgreSQL data security.

836 views06:30

https://www.timescale.com/learn/postgres-best-practices

Postgres best practices

Postgres best practices | Learn PostgreSQL | Timescale

Learn the best practices to perfect your Postgres mastery, from data management to performance fine-tuning.

1.14K views10:25

PostgreSQL DBA pinned «https://www.timescale.com/learn/postgres-best-practices Postgres best practices»

10:25

https://wiki.postgresql.org/wiki/WIP_PostgreSQL_Sharding

Sharding in database

943 views10:02

https://docs.citusdata.com/en/stable/get_started/what_is_citus.html#when-to-use-citus

Citus database

What is Citus? - Citus 13.0.1 documentation

Docs for the Citus open source extension to Postgres. Citus gives you Postgres at any scale—from a single node to a large distributed database cluster. Available as 100% open source & as a managed service with Azure Cosmos DB for PostgreSQL.

1.02K views10:03

https://www.postgresql.org/about/news/benetl-a-free-etl-tool-for-postgresql-out-in-version-58-2779/

Benetl, a free ETL tool for PostgreSQL

PostgreSQL News

Benetl, a free ETL tool for PostgreSQL, out in version 5.8

Dear all, Benetl, a free ETL tool for files working with PostgreSQL, version 5.8.0 is out. This version uses Java …

❤1

755 views05:13

https://www.cybertec-postgresql.com/en/postgresql-security-things-to-avoid-in-real-life/

CYBERTEC PostgreSQL | Services & Support

PostgreSQL Security: 12 rules for database hardening

UPDATED August 2023: PostgreSQL security - make your database safe. Follow these 12 recommendations for proactive database hardening.

779 views11:10

https://www.cybertec-postgresql.com/en/things-could-be-improved-postgresql/

CYBERTEC PostgreSQL | Services & Support

7 things that could be improved in PostgreSQL

UPDATE July 2023: What could be better in PostgreSQL? Find out about its weak points, and see what has improved since 2020.

708 views11:11

https://www.cybertec-postgresql.com/en/prewarming-postgresql-i-o-caches/

CYBERTEC PostgreSQL | Services & Support

Prewarming PostgreSQL I/O caches

How to deal with PostgreSQL restarts? pg_prewarm allows you to automatically prewarm your caches after a database failure or a simple restart

876 views11:12

https://www.cybertec-postgresql.com/en/hot-updates-in-postgresql-for-better-performance/

CYBERTEC PostgreSQL | Services & Support

HOT updates in PostgreSQL for better performance

HOT updates (Heap Only Tuple) boost PostgreSQL DML performance. This article explains the concept, shows examples and gives tuning advice.

932 views11:12

https://postgres.ai/blog/20220106-explain-analyze-needs-buffers-to-improve-the-postgres-query-optimization-process

EXPLAIN (ANALYZE) needs BUFFERS to improve the Postgres query optimization process

EXPLAIN (ANALYZE) needs BUFFERS to improve the Postgres query optimization process | Postgres.AI

<div><img src="/assets/thumbnails/20220106-explain-analyze-needs-buffers-to-improve-postgres-query-optimization-process.jpeg" alt="Io, a Jupiter's moon"/> <small>(Io, a Jupiter's moon)</small></div> <p>SQL query optimization is challenging for those who have…

882 views07:45

👍1

800 views07:46

763 views07:50

https://www.enterprisedb.com/ai-solutions-for-postgresql

PostgreSQL AI Solutions

651 views09:50

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

Postgres and the Artificial Intelligence Landscape — Bruce Momjian, EDB

Artificial intelligence, machine learning, and deep learning are intertwined capabilities that attempt to solve problems that defy traditional computational solutions — problems include fraud detection, voice recognition, and search result recommendations.…

657 views09:51

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

PostgresML: Leveraging Postgres as a Vector Database for AI

Video with transcript included on InfoQ: https://bit.ly/4aUrHmo

Montana Low provides an understanding of how Postgres can be used as a vector database for AI and how it can be integrated into your existing application stack.

#MachineLearning #PostgresML…

714 views09:53