Re: [GENERAL] meaning of default_statistics_target

2008-04-28 Thread Alvaro Herrera
Martin Marques escribió: > Is the value measured in some scale, or does it depend on something > internal? What does 1000 mean? 1000 histogram and MCV entries, and also a larger sample: >> Increasing the target also increases the number of rows that ANALYZE >> samples to prepare the stats, so

Re: [GENERAL] meaning of default_statistics_target

2008-04-28 Thread Martin Marques
Tom Lane escribió: Martin Marques <[EMAIL PROTECTED]> writes: How much, and which extra statistics information will ANALYZE gather if I set a higher value for one specific column (maybe one with and index, and heavily used in SELECT clauses)? If instead of 100 I set a column to 250, which extr

Re: [GENERAL] meaning of default_statistics_target

2008-04-28 Thread Tom Lane
Martin Marques <[EMAIL PROTECTED]> writes: > How much, and which extra statistics information will ANALYZE gather if > I set a higher value for one specific column (maybe one with and index, > and heavily used in SELECT clauses)? If instead of 100 I set a column to > 250, which extra data will I