PostgreSQL DBA
@postgres_tech
2.15K subscribers
91 photos
1 video
20 files
216 links
Sharing knowledge about postgresql database
Download Telegram
About
Blog
Apps
Platform
Join
PostgreSQL DBA
2.15K subscribers
PostgreSQL DBA
https://www.fintechfutures.com/2019/02/case-study-2ndquadrant-and-tastyworks-boosting-postgresql-database-performance-by-400/
FinTech Futures
Case study: 2ndQuadrant and tastyworks – boosting PostgreSQL database performance by 400%
CASE STUDY BY 2NDQUADRANT
2.5K views
PostgreSQL DBA
https://www.migops.com/blog/pgbackrest-the-best-postgres-backup-tool-with-a-very-active-community/
MigOps
pgBackRest - The Best Postgres Backup Tool with a very active community
pgBackRest is the world's best backup tool for Postgres that supports parallel, incremental, differential backups and backups to AWS, Azure and GCS.
2.84K views
PostgreSQL DBA
summary postgres process architecture
2.97K viewsedited  
PostgreSQL DBA
https://www.youtube.com/watch?v=aEN6D7nYwic

How to Auto back up PostgreSQL Database
YouTube
How to Auto back up PostgreSQL Database
See the source code here https://jinujawad.com/how-to-auto-back-up-postgresql-database/

How to take back up of PostgreSQL Database – Windows PC using CMD
https://www.youtube.com/watch?v=avIEnRJf5qI


Install postgress and pgadmin in windows pc
https://w…
3.19K views
PostgreSQL DBA
https://soshace.com/automated-postgresql-backups-with-nodejs-and-bash/
Soshace
Automated Postgresql Backups with NodeJS and Bash - Soshace
The database is the holy grail of your application, but, given the unpredictable nature of software, you should always be prepared for the possibility of media, hardware and software failures. If any of these failures occurs, the main objective should be…
3.56K views
PostgreSQL DBA
https://documentation.commvault.com/v11/essential/87524_postgresql.html
3.59K views
PostgreSQL DBA
https://leopard.in.ua/presentations/postgresql_and_big_data_2016/
1.74K views
PostgreSQL DBA
https://www.percona.com/blog/working-with-large-postgresql-databases/
Percona Database Performance Blog
Working With Large PostgreSQL Databases
Addressing potential issues for a large PostgreSQL database by anticipating future conditions is the goal for every DBA.
1.84K views
PostgreSQL DBA
https://www.narratordata.com/blog/using-postgresql-as-a-data-warehouse/
1.88K views
PostgreSQL DBA
https://sematext.com/blog/postgresql-performance-tuning/
Sematext
PostgreSQL Performance Tuning and Optimization Guide
Learn how to tune your PostgreSQL database for higher query performance. Optimization tips for hardware setup, database configuration...
1.84K views
PostgreSQL DBA
https://www.youtube.com/watch?v=BsOYn1CWqBA
YouTube
High Performance PostgreSQL, Tuning and Optimization Guide - Ibrar Ahmed - PostgreSQL Tutorial
Please watch Percona’s Senior Software Engineer Ibrar Ahmed as he presents his talk “High-Performance PostgreSQL - Tuning and Optimization Guide".

Comment 💬, Share 🔗, Like 👍🏻, and Subscribe ✅ to our channel + Turn on the 🔔and Get More videos about #OpenSource…
2.13K views
PostgreSQL DBA
https://bun.uptrace.dev/postgres/performance-tuning.html#cursor-pagination

PostgreSQL has many configuration options that can be adjusted to improve performance. Here are some tips for tuning PostgreSQL performance.
Bun
Tuning PostgreSQL performance [most important settings]
By following these tips, you can tune performance of your PostgreSQL database and ensure that it is running efficiently.
2.29K views
PostgreSQL DBA
PostgreSQL DBA pinned «https://bun.uptrace.dev/postgres/performance-tuning.html#cursor-pagination PostgreSQL has many configuration options that can be adjusted to improve performance. Here are some tips for tuning PostgreSQL performance.»
PostgreSQL DBA
https://docs.informatica.com/integration-cloud/data-integration-connectors/current-version/postgresql-connector/postgresql-pushdown-optimization.html
2.29K views
PostgreSQL DBA
https://pgtune.leopard.in.ua/#/

Parameters of your system
pgtune.leopard.in.ua
PGTune - calculate configuration for PostgreSQL based on the maximum performance for a given hardware configuration
PgTune - Tuning PostgreSQL config by your hardware
2.44K views
PostgreSQL DBA
2.47K views
PostgreSQL DBA
https://dbmstools.com/databases/postgresql
Dbmstools
List of tools for PostgreSQL - DBMS Tools
List of categories available for the PostgreSQL database.
2.57K views
PostgreSQL DBA
Dr. Martin Loetzsch - ETL Patterns with Postgres

https://www.youtube.com/watch?v=whwNi21jAm4
YouTube
Dr. Martin Loetzsch - ETL Patterns with Postgres
- Captured Live on Ustream at http://www.ustream.tv/channel/JUMjvCF2ucj
2.35K views
PostgreSQL DBA
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
Stack Overflow
PostgreSQL to Data-Warehouse: Best approach for near-real-time ETL / extraction of data
Background:

I have a PostgreSQL (v8.3) database that is heavily optimized for OLTP.

I need to extract data from it on a semi real-time basis (some-one is bound to ask what semi real-time means a...
2.65K views
PostgreSQL DBA
https://www.nobledesktop.com/classes-near-me/blog/why-learn-postgresql-for-data-science

Why Every Data Scientist Should Know PostgreSQL!
2.28K views