Re: DEFAULT_STATISTICS_TARGET - Mailing list pgsql-general

From Michael Fuhr
Subject Re: DEFAULT_STATISTICS_TARGET
Date
Msg-id 20060614223321.GA78630@winnie.fuhr.org
Whole thread Raw
In response to DEFAULT_STATISTICS_TARGET  ("John D. Burger" <john@mitre.org>)
Responses Re: DEFAULT_STATISTICS_TARGET
List 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

pgsql-general by date:

Previous
From: "John D. Burger"
Date:
Subject: Re: table has many to many relationship with itself - how
Next
From: Tom Lane
Date:
Subject: Re: DEFAULT_STATISTICS_TARGET