Re: Simple postgresql.conf wizard

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Cc: Gregory Stark <stark(at)enterprisedb(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, Greg Smith <gsmith(at)gregsmith(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Simple postgresql.conf wizard
Date: 2008-11-13 20:14:15
Message-ID: 21423.1226607255@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> writes:
> Another idea would be to take a large sample in ANALYZE, but if the
> distribution looks "regular enough", store less samples in the
> Most-Common-Values list and fewer histograms, to make the planning faster.

Yeah, some flexibility at that end might not be a bad idea either.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Grzegorz Jaskiewicz 2008-11-13 20:20:46 Re: Simple postgresql.conf wizard
Previous Message Tom Lane 2008-11-13 20:10:04 Re: gram.y => preproc.y