Re: Simple postgresql.conf wizard - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Simple postgresql.conf wizard
Date
Msg-id 491C761A.4030100@agliodbs.com
Whole thread Raw
In response to Re: Simple postgresql.conf wizard  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: Simple postgresql.conf wizard  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Simple postgresql.conf wizard  (Greg Stark <greg.stark@enterprisedb.com>)
List pgsql-hackers
Gregory Stark wrote:
> Josh Berkus <josh@agliodbs.com> writes:
> 
>> DW:
>>     default_statistics_target = 400
>> Mixed:
>>     default_statistics_target = 100
> 
> You, my friend, are certifiably insane.

Hmmm?  Why?  I've used those settings in the field, fairly frequently. 
I was actually wondering if we should raise the default for web as well, 
but decided to let it alone.

Actually, I think a DW should begin at 400; often it needs to go up to 
1000, but I don't think a script should do that.

--Josh



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Block-level CRC checks
Next
From: Decibel!
Date:
Subject: Re: WIP: Automatic view update rules