pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: John A Meinel <john@arbash-meinel.com>
To: Sebastian Hennebrueder <usenet@laliluna.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: Recommendations for set statistics
Date: Thu, 12 May 2005 22:36:01 -0500
Message-ID: <428420A1.9090707@arbash-meinel.com> (raw)
In-Reply-To: <428416D8.8060303@laliluna.de>
References: <428416D8.8060303@laliluna.de>

Sebastian Hennebrueder wrote:
> Hello,
>
> I could not find any recommandations for the level of set statistics and
> what a specific level does actually mean.
> What is the difference between 1, 50 and 100? What is recommanded for a
> table or column?
>

Default I believe is 10. The higher the number, the more statistics are
kept, with a maximum of 1000.

The default is a little bit low for columns used in foreign keys, though
frequently it is okay.
When problems start, try setting them to 100 or 200. Higher is more
accurate, but takes longer to compute, *and* takes longer when planning
the optimal query method. It can be worth it, though.

John
=:->

Attachments:

  signature.asc (application/pgp-signature, 250B) download

view thread (4+ messages)  latest in thread

Message-ID: <428420A1.9090707@arbash-meinel.com>
Permalink:  ../428420A1.9090707@arbash-meinel.com/
Also on:    postgresql.org/message-id/428420A1.9090707@arbash-meinel.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: john@arbash-meinel.com, usenet@laliluna.de
  Subject: Re: Recommendations for set statistics
  In-Reply-To: <428420A1.9090707@arbash-meinel.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox