| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2010-10-30 00:24:54 | Re: [PERFORM] typoed column name, but postgres didn't grump |
| Previous Message | Tom Lane | 2010-10-29 22:03:25 | Re: Slow Query- Bad Row Estimate |