Bug 1470988

Summary:	[RFE] Use parallel pg_dump for faster backups
Product:	[oVirt] ovirt-engine	Reporter:	Martin Perina <mperina>
Component:	Backup-Restore.Engine	Assignee:	Yedidyah Bar David <didi>
Status:	CLOSED WONTFIX	QA Contact:	Pavel Stehlik <pstehlik>
Severity:	medium	Docs Contact:
Priority:	low
Version:	---	CC:	bugs, ylavi
Target Milestone:	---	Keywords:	FutureFeature, Performance
Target Release:	---	Flags:	rule-engine: planning_ack? rule-engine: devel_ack? rule-engine: testing_ack?
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Enhancement
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2017-07-31 09:59:03 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	Integration	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:	1459134
Bug Blocks:	1106547

Description Martin Perina 2017-07-14 08:34:32 UTC

Description of problem:

Option to specify number of jobs [1] has been added to pg_dump to increase performance, so we could reuse this inside engine-backup.

[1] https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.3#Parallel_pg_dump_for_faster_backups

Version-Release number of selected component (if applicable):


How reproducible:


Steps to Reproduce:
1.
2.
3.

Actual results:


Expected results:


Additional info:

Comment 1 Yedidyah Bar David 2017-07-17 09:27:39 UTC

This bug also requires adding support for 'directory' format.

Comment 2 Yaniv Kaul 2017-07-27 12:20:14 UTC

Is pgpdump today too slow? I doubt we've had anyone complaining about it?

Comment 3 Sandro Bonazzola 2017-07-31 09:59:03 UTC

We have no complains about speed of backups, not sure we should spend time on this.