Re: 500x speed-down: Wrong statistics! - Mailing list pgsql-performance

From Tom Lane
Subject Re: 500x speed-down: Wrong statistics!
Date
Msg-id 29702.1136906579@sss.pgh.pa.us
Whole thread Raw
In response to Re: 500x speed-down: Wrong statistics!  (Alessandro Baretta)
Responses Re: 500x speed-down: Wrong statistics!  (Alessandro Baretta)
List pgsql-performance
Alessandro Baretta <> writes:
> I have no clue as to how or why the statistics were wrong
> yesterday--as I vacuum-analyzed continuously out of lack of any better
> idea--and I was stupid enough to re-timestamp everything before
> selecting from pg_stats.

Too bad.  I would be interested to find out how, if the stats were
up-to-date, the thing was still getting the row estimate so wrong.
If you manage to get the database back into its prior state please
do send along the pg_stats info.

            regards, tom lane

pgsql-performance by date:

Previous
From: Andrea Arcangeli
Date:
Subject: Re: NOT LIKE much faster than LIKE?
Next
From: Robert Creager
Date:
Subject: Re: Index isn't used during a join.