Postgres Pro
Downloads
Home   >   mailing lists

Re: 7.2.1 optimises very badly against 7.2 - Mailing list pgsql-general

From Tom Lane
Subject Re: 7.2.1 optimises very badly against 7.2
Date
Msg-id 17597.1026141711@sss.pgh.pa.us
Whole thread Raw
In response to Re: 7.2.1 optimises very badly against 7.2  ("Sam Liddicott" <sam.liddicott@ananova.com>)
List pgsql-general
Tree view 
"Sam Liddicott" <sam.liddicott@ananova.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

pgsql-general by date:

Previous
From: Manfred Koizar
Date:
Subject: Re: PostgreSQL doesn't use indexes even is enable_seqscan = off
Next
From: Stephan Szabo
Date:
Subject: Re: Null in the where-clause