Postgres Pro
Downloads
Home   >   mailing lists

Re: Re: Performance degradation in PostgreSQL 7.1beta3 vs 6.5.3 - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: Re: Performance degradation in PostgreSQL 7.1beta3 vs 6.5.3
Date
Msg-id 3A65D4C1.4FA008F2@tm.ee
Whole thread Raw
In response to Re: Performance degradation in PostgreSQL 7.1beta3 vs 6.5.3  (bruc@stone.congenomics.com (Robert E. Bruccoleri))
Responses Re: Re: Performance degradation in PostgreSQL 7.1beta3 vs
List pgsql-hackers
Tree view 
"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" ?

---------------
Hannu

pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: AW: AW: AW: Re: tinterval - operator problems on AIX
Next
From: bruc@stone.congenomics.com (Robert E. Bruccoleri)
Date:
Subject: Re: Re: Performance degradation in PostgreSQL 7.1beta3 vs