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
170
PostgreSQL DBA

13 Jan, 08:05

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

SQL Workbench/J
169
PostgreSQL DBA

13 Jan, 08:01

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

Hot standby!
166
PostgreSQL DBA

13 Jan, 07:59

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

Resolving common problems with PostgreSQL Streaming Replication
162
PostgreSQL DBA

08 Jan, 10:43

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

Triggers in PostgreSQL
330
PostgreSQL DBA

08 Jan, 09:34

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

Triggers on views!
321
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
870
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
701
PostgreSQL DBA

09 Dec, 08:00

https://github.com/gcbeltramini/etl-postgresql
533
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
538
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
506
PostgreSQL DBA

27 Nov, 05:54

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

27 Nov, 05:53

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

28 Oct, 08:51

https://medium.com/quadcode-life/toast-tables-in-postgresql-99e3403ed29b
1,213
PostgreSQL DBA

28 Oct, 08:49

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

How Postgres handles data storage of oversized attributes.
1,128
PostgreSQL DBA

23 Oct, 06:06

https://www.youtube.com/watch?v=feMOYE3HuNM
1,114
PostgreSQL DBA

23 Oct, 06:05

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

Understanding about TOAST

Join PostgreSQL
868
PostgreSQL DBA

10 Oct, 05:46

https://www.youtube.com/watch?v=fRiLNXeqrWg
1,132
PostgreSQL DBA

10 Oct, 05:44

https://www.postgresql.org/docs/current/dblink.html
962
PostgreSQL DBA

10 Oct, 05:43

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

08 Oct, 06:57

https://www.postgresql.org/docs/release/17.0/
906
PostgreSQL DBA

08 Oct, 06:52

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

08 Oct, 06:52

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

30 Sep, 03:03

https://stackoverflow.com/questions/29593171/data-mining-with-postgres-in-production-environment-is-there-a-better-way
988
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
1,327
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
985
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
839
PostgreSQL DBA

23 Aug, 09:33

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

What is pgvector and How Can It Help You?
1,327
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
1,216
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
967
PostgreSQL DBA

23 Aug, 06:53

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

Understanding about PostgreSQL Architecture!
992
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.
871

2025 All Right Reserved

Disclaimer: The content displayed on this website is solely provided by the respective Telegram channels. We hold no ownership or responsibility for the content shared by these channels.