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
---(end of broadcast)---
TIP 6: explain analyze is your friend
"John D. Burger" <[EMAIL PROTECTED]> 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 kn
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.postgresq
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 tha
