Re: DEFAULT_STATISTICS_TARGET - Mailing list pgsql-general

From Tom Lane
Subject Re: DEFAULT_STATISTICS_TARGET
Date
Msg-id 4762.1150324562@sss.pgh.pa.us
Whole thread Raw
In response to DEFAULT_STATISTICS_TARGET  ("John D. Burger" <john@mitre.org>)
List pgsql-general
"John D. Burger" <john@mitre.org> writes:
> Is there any way to set DEFAULT_STATISTICS_TARGET on a permanent basis
> for a particular database?  SET DEFAULT_STATISTICS_TARGET is only per
> session, apparently, and I'm not sure I want to set it for the whole
> cluster in the config file.  I know I can fix it per-column with ALTER
> TABLE, but that's a bit of a pain.
> I'm running 7.4.  Thanks for any info.

ALTER DATABASE SET, same as most other GUC variables ...

            regards, tom lane

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: DEFAULT_STATISTICS_TARGET
Next
From: Chris Browne
Date:
Subject: Re: Fabian Pascal and RDBMS deficiencies in fully implementing