PostgreSQL DBA @postgres_tech Channel on Telegram

PostgreSQL DBA

@postgres_tech


Sharing knowledge about postgresql database

PostgreSQL DBA (English)

Are you passionate about PostgreSQL database management? Look no further than the PostgreSQL DBA channel on Telegram! With the username @postgres_tech, this channel is dedicated to sharing valuable knowledge and insights about PostgreSQL database administration. Whether you're a seasoned DBA looking to enhance your skills or a newcomer eager to learn the ropes, this channel is the perfect place for you. From tips and tricks for optimizing PostgreSQL performance to best practices for data backup and recovery, you'll find a wealth of information that will help you excel in your role. Join the PostgreSQL DBA channel today and take your database administration skills to the next level!

PostgreSQL DBA

13 Jan, 08:06


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 DBA

13 Jan, 08:05


https://www.sql-workbench.eu/index.html

SQL Workbench/J

PostgreSQL DBA

13 Jan, 08:01


https://www.postgresql.org/docs/current/hot-standby.html

Hot standby!

PostgreSQL DBA

13 Jan, 07:59


https://dbvisit.com/blog/resolving-common-problems-with-postgresql-data-streaming

Resolving common problems with PostgreSQL Streaming Replication

PostgreSQL DBA

08 Jan, 10:43


https://medium.com/@kalaranibe/mastering-postgresql-triggers-a-beginners-guide-cda8d0578866

Triggers in PostgreSQL

PostgreSQL DBA

08 Jan, 09:34


https://www.depesz.com/2010/10/16/waiting-for-9-1-triggers-on-views/

Triggers on views!

PostgreSQL DBA

09 Dec, 08:01


https://www.linkedin.com/pulse/historical-data-tracking-postgresql-part-2-trigger-mart%C3%ADnez-verd%C3%BA/?trk=article-ssr-frontend-pulse_little-text-block

Historical Data Tracking in PostgreSQL - Part 2: Trigger Functions

PostgreSQL DBA

09 Dec, 08:01


https://www.linkedin.com/pulse/historical-data-tracking-postgresql-part-1-jaime-mart%C3%ADnez-verd%C3%BA/?trk=article-ssr-frontend-pulse_little-text-block

Historical Data Tracking in PostgreSQL - Part 1: Historical Table and Triggers

PostgreSQL DBA

09 Dec, 08:00


https://github.com/gcbeltramini/etl-postgresql

PostgreSQL DBA

09 Dec, 06:37


https://www.linkedin.com/pulse/building-data-warehouse-fundamentals-principles-postgresql-r-s-j1tyc

Building a Data Warehouse: Fundamentals, Principles, and PostgreSQL Implementation

PostgreSQL DBA

09 Dec, 06:36


https://stackoverflow.com/questions/2519985/postgresql-to-data-warehouse-best-approach-for-near-real-time-etl-extraction

PostgreSQL to Data-Warehouse: Best approach for near-real-time ETL / extraction of data

PostgreSQL DBA

27 Nov, 05:54


https://www.linkedin.com/pulse/postgresql-tutorial-how-setup-streaming-replication-mahto-k1clf

PostgreSQL DBA

27 Nov, 05:53


https://www.postgresql.org/docs/current/protocol-replication.html

PostgreSQL DBA

28 Oct, 08:51


https://medium.com/quadcode-life/toast-tables-in-postgresql-99e3403ed29b

PostgreSQL DBA

28 Oct, 08:49


https://www.gojek.io/blog/a-toast-from-postgresql

How Postgres handles data storage of oversized attributes.

PostgreSQL DBA

23 Oct, 06:06


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

PostgreSQL DBA

23 Oct, 06:05


https://www.postgresql.org/docs/current/storage-toast.html

Understanding about TOAST

Join PostgreSQL

PostgreSQL DBA

10 Oct, 05:46


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

PostgreSQL DBA

10 Oct, 05:44


https://www.postgresql.org/docs/current/dblink.html

PostgreSQL DBA

10 Oct, 05:43


https://www.postgresql.org/docs/current/contrib-dblink-function.html

PostgreSQL DBA

08 Oct, 06:57


https://www.postgresql.org/docs/release/17.0/

PostgreSQL DBA

08 Oct, 06:52


https://www.citusdata.com/blog/2014/04/03/columnar-store-for-analytics/

PostgreSQL DBA

08 Oct, 06:52


https://www.postgresql.fastware.com/blog/where-and-how-does-postgresql-actually-store-data-on-disk

PostgreSQL DBA

30 Sep, 03:03


https://stackoverflow.com/questions/29593171/data-mining-with-postgres-in-production-environment-is-there-a-better-way

PostgreSQL DBA

17 Sep, 06:47


https://towardsdatascience.com/how-to-build-a-data-lake-from-scratch-part-2-connecting-the-components-1bc659cb3f4f
How to build a data lake from scratch — Part 2: Connecting the components

PostgreSQL DBA

17 Sep, 06:47


https://towardsdatascience.com/how-to-build-a-data-lake-from-scratch-part-1-the-setup-34ea1665a06e

How to build a data lake from scratch — Part 1: The setup

PostgreSQL DBA

17 Sep, 06:45


https://www.starburst.io/blog/scaling-up-when-to-migrate-from-postgresql-to-a-data-lake/

Scaling Up: When to Migrate from PostgreSQL to a Data Lake

PostgreSQL DBA

23 Aug, 09:33


https://www.enterprisedb.com/blog/what-is-pgvector

What is pgvector and How Can It Help You?

PostgreSQL DBA

23 Aug, 07:33


https://www.highgo.ca/2020/08/10/postgresql-high-availability-the-considerations-and-candidates/

PostgreSQL High Availability: The Considerations and Candidates

PostgreSQL DBA

23 Aug, 07:30


https://pgstatsinfo.sourceforge.net/documents/statsinfo_old/pg_statsinfo2.2.html

pg_statsinfo monitors an instance of PostgreSQL server

PostgreSQL DBA

23 Aug, 06:53


https://medium.com/@sumeet.k.shukla/postgresql-architecture-6df259dc1145

Understanding about PostgreSQL Architecture!

PostgreSQL DBA

19 Aug, 06:18


What is parallel querying in PostgreSQL?
Parallel querying is a technique in PostgreSQL that allows you to create query plans that can leverage multiple CPUs to answer queries more efficiently. This technique is particularly well-suited when the query involves scanning a lot of data but returning a few rows, for example, aggregate calculations.

2,075

subscribers

23

photos

20

videos