Re: DEFAULT_STATISTICS_TARGET

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: "John D(dot) Burger" <john(at)mitre(dot)org>
Cc: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Re: DEFAULT_STATISTICS_TARGET
Date: 2006-06-14 22:33:21
Message-ID: 20060614223321.GA78630@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jun 14, 2006 at 06:21:35PM -0400, John D. Burger wrote:
> Is there any way to set DEFAULT_STATISTICS_TARGET on a permanent basis
> for a particular database?

You can use ALTER DATABASE. New sessions will get the new value;
you'll need to reconnect to see the effect.

http://www.postgresql.org/docs/7.4/interactive/sql-alterdatabase.html

--
Michael Fuhr

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Browne 2006-06-14 22:34:08 Re: Fabian Pascal and RDBMS deficiencies in fully implementing
Previous Message John D. Burger 2006-06-14 22:32:57 Re: table has many to many relationship with itself - how