Project

General

Profile

Feature #4023

PostgreSQL query planning optimization

Added by Eric Faulhaber about 5 years ago. Updated about 5 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Target version:
-
Start date:
Due date:
% Done:

0%

billable:
No
vendor_id:
GCD
version:

History

#1 Updated by Eric Faulhaber about 5 years ago

To date, we have not made a concentrated effort to tune PostgreSQL's query planner for FWD's use, beyond some basics: increasing shared_buffers, work_mem, and temp_buffers. We have yet to go a level deeper and see what some of the more powerful configuration parameters (such as the cost-based estimates) can do for performance. We probably need to invest in the time of an expert DBA to get some advice.

Beyond this, would it make sense to hire an expert PostgreSQL developer to make changes to the query planner itself? This idea is probably premature before taking the DBA step first, but it is documented here as a placeholder for now.

Also available in: Atom PDF