Re: Re: Performance degradation in PostgreSQL 7.1beta3 vs

Dear Hannu,
> 
> "Robert E. Bruccoleri" wrote:
> > 
> > explain select count(*) from comparisons_4 where code = 80003;
> > NOTICE:  QUERY PLAN:
> > 
> > Aggregate  (cost=15659.29..15659.29 rows=1 width=0)
> >   ->  Seq Scan on comparisons_4  (cost=0.00..15640.81 rows=7391 width=0)
> > 
> > EXPLAIN
> 
> What is the type of field "code" ?

int4

Do you think that should make a difference?

+----------------------------------+------------------------------------+
| Robert E. Bruccoleri, Ph.D.      | Phone: 609 737 6383                |
| President, Congenomics, Inc.     | Fax:   609 737 7528                |
| 114 W Franklin Ave, Suite K1,4,5 | email: bruc@acm.org                |
| P.O. Box 314                     | URL:   http://www.congen.com/~bruc |
| Pennington, NJ 08534             |                                    |
+----------------------------------+------------------------------------+