Postgres Pro
Downloads
Home   >   mailing lists

Changing tuning parameters with EXPLAIN - Mailing list pgsql-novice

From Antonio Carlos Salzvedel Furtado Junior
Subject Changing tuning parameters with EXPLAIN
Date
Msg-id CAERqmVorUFACg8YKiVQevyeupZVZfHb6va-Fyy+NwDDu_7-tRA@mail.gmail.com
Whole thread Raw
Responses Re: Changing tuning parameters with EXPLAIN
List pgsql-novice
Tree view
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

pgsql-novice by date:

Previous
From: "Van Orden, Brad"
Date:
Subject: Re: database in different location owned by different user
Next
From: Jeff Davis
Date:
Subject: Re: Changing tuning parameters with EXPLAIN