Postgres Pro
Downloads
Home   >   mailing lists

Re: Plan selection based on worst case scenario - Mailing list pgsql-performance

From Chema
Subject Re: Plan selection based on worst case scenario
Date
Msg-id CALdEsqNDDMgBgOF8HYwuCG6DL0ALf8BZObn9_Qf+mSVAH-KdwA@mail.gmail.com
Whole thread Raw
In response to Plan selection based on worst case scenario  ("Darwin O'Connor" <doconno@gmail.com>)
List pgsql-performance
Tree view

Hey Darwin,

you don't mention your version or config, but it's always good to go through https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server

I used to notice huge improvements in plans when increasing statistics in relevant columns, as already suggested by David, and also by lowering random_page_cost, especially in older Pg versions. 

pgsql-performance by date:

Previous
From: David Rowley
Date:
Subject: Re: Plan selection based on worst case scenario
Next
From: Satalabaha Postgres
Date:
Subject: query column in pg_stat_statements and pg_stat_activity