DEFAULT_STATISTICS_TARGET

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

"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

You can use ALTER DATABASE.

Argh! I somehow missed that despite reading the Run-time Configuration
section three times ... Thanks, folks!

- John D. Burger
MITRE