Skip site navigation (1) Skip section navigation (2)

Re: Slow Query- Bad Row Estimate

From: "Ozer, Pam" <pozer(at)automotive(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Josh Berkus" <josh(at)agliodbs(dot)com>,<pgsql-performance(at)postgresql(dot)org>
Subject: Re: Slow Query- Bad Row Estimate
Date: 2010-10-29 22:10:16
Message-ID: 216FFB77CBFAEE4B8EE4DF0A939FF1D101835B@mail-001.corp.automotive.com (view raw or flat)
Thread:
Lists: pgsql-performance
Its 8.4.  On the column stats_target=-1 before I changed it.  AutoVacuum
is set to on.  I actually did a full analyze of the database and then
ran it again.  So what am I missing?

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us] 
Sent: Friday, October 29, 2010 3:03 PM
To: Ozer, Pam
Cc: Josh Berkus; pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] Slow Query- Bad Row Estimate 

"Ozer, Pam" <pozer(at)automotive(dot)com> writes:
> Yes.  The default statistics target was at 1000.  So that would be
what the column was using correct?

But you evidently didn't have stats.  Perhaps you have autovacuum turned
off?  What PG version is this anyway?

			regards, tom lane

In response to

pgsql-performance by date

Next:From: Robert HaasDate: 2010-10-30 00:24:54
Subject: Re: [PERFORM] typoed column name, but postgres didn't grump
Previous:From: Tom LaneDate: 2010-10-29 22:03:25
Subject: Re: Slow Query- Bad Row Estimate

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group