Jira (PDB-5165) Add Estate Reporting queries to performance test

Bogdan Irimie (Jira)

unread,

Jun 30, 2021, 2:41:01 AM6/30/21

to puppe...@googlegroups.com

Bogdan Irimie created an issue

PuppetDB /

PDB-5165

Add Estate Reporting queries to performance test

Issue Type:	Task
Assignee:	Unassigned
Created:	2021/06/29 11:40 PM
Priority:	Normal
Reporter:	Bogdan Irimie

Add Comment

This message was sent by Atlassian Jira (v8.13.2#813002-sha1:c495a97)

Bogdan Irimie (Jira)

unread,

Jun 30, 2021, 2:54:02 AM6/30/21

to puppe...@googlegroups.com

Bogdan Irimie updated an issue

PuppetDB /

PDB-5165

Add Estate Reporting queries to performance test

Change By:	Bogdan Irimie

* Add queries generated by Estate Reporting to our performance test tool based on locust. The queries will be provided by the Estate Reporting team [~david.woods] in https://tickets.puppetlabs.com/browse/LIDAR-915
* generate results for 10 000 up to 500 000 nodes and identify slow queries or possible errors. Initially we should use n1/n2 servers and if they can't handle the load consider using EC2 instances form AWS.
* The deployment will be composed of 1 postgresql and 1 PDB. if PDB becomes a bottleneck, we should scale to multiple PDB and add a load balancer in front of them. If PostgreSql becomes the bottleneck we should:
** identify the queries that are slow
** scale PostgreSQL horizontally
** tweak PostgreSQL settings or PDB settings