Hello PostgreSQL users,
I've been working with the estimated cost from EXPLAIN. I was wondering if
I could change the tuning parameters, to produce new estimated costs,
without interfering with the database workload. Is it possible?
I'm changing these parameters by executing SQL queries ("SET"). The problem
is that once I change these parameters, the query optimizer will start
using these values to build their query plans.
Antonio Carlos Furtado
pgsql-novice by date
|Next:||From: Jeff Davis||Date: 2012-06-04 21:01:08|
|Subject: Re: Changing tuning parameters with EXPLAIN|
|Previous:||From: Van Orden, Brad||Date: 2012-06-04 12:46:13|
|Subject: Re: database in different location owned by different user|