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

From Grzegorz Jaskiewicz
Subject Re: Simple postgresql.conf wizard
Date
Msg-id 93EE8B16-EA90-4E2A-B5E1-16E6AEEC4899@pointblue.com.pl
Whole thread Raw
In response to Re: Simple postgresql.conf wizard  (Greg Stark <greg.stark@enterprisedb.com>)
Responses Re: Simple postgresql.conf wizard  ("Jonah H. Harris" <jonah.harris@gmail.com>)
List pgsql-hackers
On 2008-11-13, at 19:33, Greg Stark wrote:

> A statistic target of 400 fir a specific column may make sense but  
> even then I would recommend monitoring performance to ensure it  
> doesn't cause problems. As a global setting it's, IMHO, ridiculous.
>

If that's the situation, me thinks you guys have to start thinking  
about some sort of automated way to increase this param per column as  
needed.
Is there any way planner could actually tell, that it would do better  
job with more stats for certain column ?



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Simple postgresql.conf wizard
Next
From: Tom Lane
Date:
Subject: Re: gram.y => preproc.y