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://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.

919 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.

791 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.

767 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.

911 views06:29

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

PostgreSQL Database Hardening

769 views06:30

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

Best Practices for Postgres Security

Best Practices for Postgres Security | TigerData

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

913 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.25K 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

1.04K 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.1K 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

831 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.

863 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.

789 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

956 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.

1.01K 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 | PostgresAI

<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…

982 views07:45

👍1

903 views07:46

863 views07:50

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

PostgreSQL AI Solutions

747 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.…

757 views09:51