cybrosys

In this DBBlue Feature Series video, we explore Fast Restore, one of the PostgreSQL enhancements developed by the PostgreSQL Research and Development Team at Cybrosys Technologies. DBBlue is a customized PostgreSQL distribution built by modifying the PostgreSQL source code to optimize database performance and administration for Odoo workloads. Instead of requiring database administrators to manually tune PostgreSQL, DBBlue introduces intelligent features that automate common database operations and improve overall efficiency. In this video, we demonstrate how DBBlue Fast Restore automatically enables parallel restore for PostgreSQL custom-format backups when the -j option is not specified, significantly reducing restore time for large Odoo databases while requiring no additional configuration. What You'll Learn in This Video - What DBBlue is and why it was developed. - The limitations of standard PostgreSQL restore using a single worker. - How to restore a PostgreSQL custom-format (.dump) backup using pg_restore. - Monitor restore activity using pg_stat_activity. - Compare restore performance between standard PostgreSQL and DBBlue. - How DBBlue automatically selects the optimal number of restore workers. - Understand the automatic worker selection algorithm. - Why DBBlue limits automatic parallel restore to a maximum of eight workers. - How DBBlue balances restore performance with PostgreSQL connection usage. - When to manually override the worker count using the `-j` option. Commands Demonstrated List available PostgreSQL clusters pg_lsclusters Switch to the PostgreSQL superuser sudo su postgres Restore a PostgreSQL custom-format backup time pg_restore \ -d odoo_database \ backup.dump Monitor active restore operations SELECT * FROM pg_stat_activity WHERE state ILIKE '%copy%'; Automatic Worker Selection in DBBlue DBBlue automatically determines the number of parallel restore workers whenever the -j option is not specified during a pg_restore operation. On a single-core machine, DBBlue uses one restore worker. For systems with 2 to 8 CPU cores, it automatically uses the same number of restore workers as the available CPU cores, allowing the restore process to take full advantage of the hardware. On systems with more than 8 CPU cores, DBBlue limits the automatic worker count to 8. This balanced approach delivers excellent restore performance while preventing excessive PostgreSQL connection usage. If a different worker count is required, database administrators can still specify it manually using the -j option. This approach provides excellent restore performance while preventing excessive PostgreSQL connection usage in production environments. Why Fast Restore? Large Odoo databases can take a significant amount of time to restore using standard PostgreSQL because the restore process runs sequentially unless parallel workers are manually specified. DBBlue removes this manual step by automatically enabling parallel restore with an intelligent worker count, allowing administrators to restore databases faster without changing their existing workflow. About DBBlue DBBlue is an Odoo-optimized PostgreSQL distribution developed by the PostgreSQL R&D Team at Cybrosys Technologies. By enhancing the PostgreSQL source code, DBBlue introduces intelligent features focused on improving performance, administration, backup and restore, indexing, caching, security, and automation specifically for Odoo databases. Connect With Us: ————————————— ➡️ Website: https://www.cybrosys.com/ ➡️ Email: info@cybrosys.com ➡️ Twitter: https://x.com/Cybrosys ➡️ LinkedIn: https://www.linkedin.com/company/cybrosys/ ➡️ Facebook: https://www.facebook.com/cybrosystechnologies/ ➡️ Instagram: https://www.instagram.com/cybrosystech/ ➡️ Pinterest: https://www.pinterest.com/cybrosys/ #Dbblue #DatabaseFeature #FastRestore #DBBlueFeatures #CybrosysTechnologies #DatabaseManagement #DataRecovery #TechSolutions #SoftwareDevelopment #clouddatabase