"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
- [HACKERS] Performance degradation in PostgreSQL 7.1be... Robert E. Bruccoleri
- [HACKERS] Re: Performance degradation in Postgre... Tom Lane
- [HACKERS] Re: Performance degradation in Pos... Robert E. Bruccoleri
- Re: [HACKERS] Re: Performance degradatio... Hannu Krosing
- Re: [HACKERS] Re: Performance degrad... Robert E. Bruccoleri
- Re: [HACKERS] Re: Performance d... Hannu Krosing
- Re: [HACKERS] Re: Performan... Robert E. Bruccoleri
- Re: [HACKERS] Re: Perfo... Hannu Krosing
- [HACKERS] Re: Performance degradation in Postgre... mlw