Changing tuning parameters with EXPLAIN

From: Antonio Carlos Salzvedel Furtado Junior <acsfj08(at)inf(dot)ufpr(dot)br>
To: pgsql-novice(at)postgresql(dot)org
Subject: Changing tuning parameters with EXPLAIN
Date: 2012-06-04 20:49:45
Message-ID: CAERqmVorUFACg8YKiVQevyeupZVZfHb6va-Fyy+NwDDu_7-tRA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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.

Cordially,

Antonio Carlos Furtado

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Jeff Davis 2012-06-04 21:01:08 Re: Changing tuning parameters with EXPLAIN
Previous Message Van Orden, Brad 2012-06-04 12:46:13 Re: database in different location owned by different user