pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Csaba Nagy <nagy@ecircle-ag.com>
To: Ron Mayer <rm_pg@cheapcomplexdevices.com>
Cc: postgres performance list <pgsql-performance@postgresql.org>
Subject: Re: Searching for the cause of a bad plan
Date: Fri, 28 Sep 2007 10:12:10 +0200
Message-ID: <1190967130.5430.85.camel@PCD12478> (raw)
In-Reply-To: <46FBF174.1020206@cheapcomplexdevices.com>
References: <1190369024.4661.173.camel@PCD12478>
	<6175.1190390913@sss.pgh.pa.us>
	<1190396352.4202.109.camel@ebony.site>
	<13644.1190397220@sss.pgh.pa.us>
	<1190399879.4202.127.camel@ebony.site>
	<27857.1190417434@sss.pgh.pa.us>
	<1190640429.4181.165.camel@ebony.site>
	<1190818357.5430.29.camel@PCD12478>
	<21582.1190820137@sss.pgh.pa.us>
	<1190894004.5430.46.camel@PCD12478>
	<29186.1190904025@sss.pgh.pa.us>
	<1190906166.5430.76.camel@PCD12478>
	<46FBF174.1020206@cheapcomplexdevices.com>

On Thu, 2007-09-27 at 11:07 -0700, Ron Mayer wrote:
> Csaba Nagy wrote:
> > 
> > Well, my problem was actually solved by rising the statistics target,
> 
> Would it do more benefit than harm if postgres increased the
> default_statistics_target?
> 
> I see a fair number of people (myself included) asking questions who's
> resolution was to ALTER TABLE SET STATISTICS; and I think relatively
> fewer (if any?) people concerned about space in pg_statistic
> or people improving analyze time by reducing the statistics target.

Well, the cost of raising the statistics target is far from zero: with
all defaults the analyze time was ~ 10 seconds, with one column set to
100 was ~ 1.5 minutes, with one column set to 1000 was 15 minutes for
the table in question (few 100M rows). Of course the IO load must have
been proportional to the timings... so I'm pretty sure the current
default is serving well most of the situations.

Cheers,
Csaba.







view thread (26+ messages)  latest in thread

Message-ID: <1190967130.5430.85.camel@PCD12478>
Permalink:  ../1190967130.5430.85.camel@PCD12478/
Also on:    postgresql.org/message-id/1190967130.5430.85.camel@PCD12478

 · 

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: nagy@ecircle-ag.com, rm_pg@cheapcomplexdevices.com
  Subject: Re: Searching for the cause of a bad plan
  In-Reply-To: <1190967130.5430.85.camel@PCD12478>

* 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