Re: Automatic Disk Partitioning

2024-08-08 Thread Geoff Steckel
On 8/8/24 02:39, Eric Furman wrote: On Wed, Aug 7, 2024, at 8:44 PM, Justin Yates Fletcher wrote: On Wed, 2024-08-07 at 01:50 +0200, David Uhden Collado wrote: Now I understand the rationale. It might be beneficial for the installer to offer multiple templates when selecting the automatic pa

Re: Optimization Advice for High Resource Utilization PostgreSQL Query on OpenBSD

2024-08-08 Thread Kihaguru Gathura
Hi Christian, Thank you for your interest and suggestion. To give you an idea, here are the approximate row counts for the main tables involved in the query: - operations.requisitions: ~50,000 rows - operations.requisition_items: ~150,000 rows - operations.products: ~20,000 rows - op

Re: Optimization Advice for High Resource Utilization PostgreSQL Query on OpenBSD

2024-08-08 Thread Kihaguru Gathura
Hi J, Thank you for your detailed response and the practical advice. To address your points: *> CPU Utilization*: I understand that CPU consumption is not inherently bad and can be indicative of the system doing its job. The query performance from an end-user perspective is acceptable at the mom