Re: Plan selection based on worst case scenario

From: Chema <chema(at)interneta(dot)org>
To: "Darwin O'Connor" <doconno(at)gmail(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Plan selection based on worst case scenario
Date: 2024-05-30 04:03:16
Message-ID: CALdEsqNDDMgBgOF8HYwuCG6DL0ALf8BZObn9_Qf+mSVAH-KdwA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Satalabaha Postgres 2024-06-04 06:46:09 query column in pg_stat_statements and pg_stat_activity
Previous Message David Rowley 2024-05-30 01:44:45 Re: Plan selection based on worst case scenario