Re: 7.2.1 optimises very badly against 7.2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Sam Liddicott" <sam(dot)liddicott(at)ananova(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 7.2.1 optimises very badly against 7.2
Date: 2002-07-08 15:21:51
Message-ID: 17597.1026141711@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Sam Liddicott" <sam(dot)liddicott(at)ananova(dot)com> writes:
> O notice missing in the 7.2.1 (slow) explain analyse this part:
> "Index Scan using idx_broadcast_channelregionid on broadcast"

Indeed. What do 7.2 and 7.2.1 have in the pg_stats row for
broadcast.channelregionid? What is the real distribution of that
column?

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Carmen Wai 2002-07-08 15:27:40 Error code
Previous Message Oliver Elphick 2002-07-08 14:54:47 Re: date problem and set style european