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

help / color / mirror / Atom feed
From: Ron Mayer <rm_pg@cheapcomplexdevices.com>
To: Csaba Nagy <nagy@ecircle-ag.com>
Subject: Re: Searching for the cause of a bad plan
Date: Thu, 27 Sep 2007 11:07:48 -0700
Message-ID: <46FBF174.1020206@cheapcomplexdevices.com> (raw)
In-Reply-To: <1190906166.5430.76.camel@PCD12478>
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>

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.



view thread (26+ messages)  latest in thread

Message-ID: <46FBF174.1020206@cheapcomplexdevices.com>
Permalink:  ../46FBF174.1020206@cheapcomplexdevices.com/
Also on:    postgresql.org/message-id/46FBF174.1020206@cheapcomplexdevices.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: rm_pg@cheapcomplexdevices.com, nagy@ecircle-ag.com
  Subject: Re: Searching for the cause of a bad plan
  In-Reply-To: <46FBF174.1020206@cheapcomplexdevices.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